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@gmx.net
