Re: problems with single quotes.. - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: problems with single quotes..
Date
Msg-id 20011202212229.C86964-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: problems with single quotes..  ("postgresql" <pgsql@symcom.com>)
List pgsql-sql
On Sun, 2 Dec 2001, postgresql wrote:

> but this is exactally correct behavior.....you can use either two single quotes to
> escape the quote or the backslash so.....
>
>  '  ''   \\   ''   '
> singlequote to start the sequence(string)
> two singlequotes to insert an escape then a singlequote (yields a single quote)
> a backslash to escape the following backslash (yields a single backslash)
> two singlequotes to insert an escape then a singlequote (yields a single quote)
> then ended by a single quote
>
> this is acting correctly.....

Yes.  I'm assuming that '\' was what he wanted out, so I gave
the sequence that worked for me.  He said he'd tried escaping
the backslash and didn't have it work, but I'm not sure what
he meant by that.



pgsql-sql by date:

Previous
From: "postgresql"
Date:
Subject: Re: problems with single quotes..
Next
From: "Steve Brett"
Date:
Subject: Re: persistent connections, AOLserver (Was: maybe Offtopic : PostgreSQL & PHP ?)