DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:References:Mime-Version:In-Reply-To:X-Apple-Yahoo-Original-Message-Folder:Content-Type:Content-Transfer-Encoding:Message-Id:Cc:X-Mailer:From:X-Apple-Yahoo-Replied-Msgid:Subject:Date:To;
	b=K+1DLPSrOevnAsF45TewdjbqkKmlqwYNbVCmMvKbIM3AHiB5dfKH2SIw2emkPxof5b6sb+ykmdr/3OeQyBPT44fRlxssHKbzIxyu3VNEZXcgUg6M+FiuiCCLM1dYXhO7plKsjOvydWg5xxevf8WcnUZ4lgIl1ZbbvA1UqjOdkig=
	;
References: <201111040738.29303.johnf@jfcomputer.com>
	<201111040826.16177.johnf@jfcomputer.com>
Mime-Version: 1.0 (iPad Mail 8J2)
In-Reply-To: <201111040826.16177.johnf@jfcomputer.com>
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Message-Id: <5B6EF5E5-F941-4D32-AF03-6BBCD6E83769@yahoo.com>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
From: David Johnston <polobo@yahoo.com>
Subject: Re: the use of $$string$$
Date: Fri, 4 Nov 2011 12:05:19 -0400
To: John Fabiani <johnf@jfcomputer.com>

On Nov 4, 2011, at 11:26, John Fabiani <johnf@jfcomputer.com> wrote:

> On Friday, November 04, 2011 07:38:29 am John Fabiani wrote:
>> Hi,
>> I just discovered that I can use $$string$$ to account for the problem of=

>> single quotes in the string (or other strange char's).  However, I notice=
d
>> that the table field contained E'string'.  I actually tried to find info o=
n
>> this but I did not find anything.
>>=20
>> Could someone explain what it means or better provide a web link for me t=
o
>> discover the info.
>>=20
>> Thanks in advance,
>> Johnf
>=20
>=20
> Thank you both for the quick replies and the links. =20
>=20
> What I still do not understand (I'm a little slow) is the fact that pgadmi=
n3=20
> showed the data as E'string'.  So I'm wondering if the data is now differe=
nt=20
> in the sense that I need use the 'E' in the field.
>=20
> For example I have the last name of O'Reilly
> the field lname now appears to contain E'O'Reilly'
>=20
> So will the normal select statements work;
>=20
> Select * from table where lname =3D 'O'' Reilly'
> Select * from table where lname like 'O%'
>=20
> or will I need to know the data contains the "E"  and add the 'E' to the s=
ql=20
> statements?
>=20
> Thanks
> Johnf
>=20
>=20

Try it and see.

If, indeed, the E is part of the data you should fix your process.  Done cor=
rectly there should be no difference in the end result regardless of how you=
 choose to identify your strings.

Don't use pgadmin3 myself so I don't know if what you are looking at would i=
nclude the E.  If it is outputting DDL (I.e., INSERT statements) it might bu=
t simple SELECT results should not.

David J.=