| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | postgresql <pgsql(at)symcom(dot)com> |
| Cc: | Megalex <megalex(at)klanomega(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: problems with single quotes.. |
| Date: | 2001-12-03 05:23:41 |
| Message-ID: | 20011202212229.C86964-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tapan Trivedi | 2001-12-03 12:04:51 | Inline IF condition |
| Previous Message | Steve Frampton | 2001-12-03 05:03:36 | ODBC queries die; "Unexpected protocol character from backend" |