On Mon, 2005-03-28 at 13:27 -0500, Iulian Popescu wrote:
> Is it something wrong with doing a:
>
> SELECT quote('AA'AA')
>
Yes, it is a syntax error. The ' character within
a string in SQL is doubled to quote it - like in
Pascal. That's the rules of SQL - I did not make
this stuff up.
The following works:
SELECT quote('AA''AA');
Compare the output against this:
SELECT 'AA''AA';
--
D. Richard Hipp <[EMAIL PROTECTED]>
