| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | postgresql <pgsql(at)symcom(dot)com> |
| Cc: | PgSQL-SQL <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: double quote handling? |
| Date: | 2002-01-27 16:05:51 |
| Message-ID: | Pine.LNX.4.30.0201271104340.687-100000@peter.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
postgresql writes:
> I did not find in the changes faq any reference to the handling of
> double quotes. In my testing at home I noticed that 7.2 was
> accepting:
>
> update table set col = 'this is a "test"' where col2 = '1800';
>
> Maybe I was wrong, but I thought I had to escape the double quotes.
You were wrong. Sorry. ;-)
(Don't confuse double quotes within single-quoted string literals with
double-quoted identifiers, within which you have to escape double quotes.)
--
Peter Eisentraut peter_e(at)gmx(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ross J. Reedstrom | 2002-01-27 22:31:05 | Re: LIMIT Optimization |
| Previous Message | Peter Eisentraut | 2002-01-27 16:02:33 | Re: pltcl build problem on FreeBSD (was: Re: pltlc and |