Forum OpenACS Development: Re: SQL backslash escapes and bind variables in the aolserver postgres driver

Collapse
2: Re: SQL backslash escapes and bind variables in the aolserver postgres driver (response to 1)
Posted by Don Baccus on 06/04/08 06:34 PM
So, don't escape single quotes in SQL statements with a backslash!
But this is a PG-ism in the first place, isn't it? Isn't the double single-quote the SQL standard, and required if you want the string to work in Oracle + PG in the first place?
Collapse
3: Re: SQL backslash escapes and bind variables in the aolserver postgres driver (response to 2)
Posted by Gustaf Neumann on 06/04/08 07:36 PM
The backslash substitution in PG is a non-standard postgres legacy and deprecated also in PG, but the extended syntax (with the preceding E) is supported.

There seem to be quite a few places, where the non-standard backslash substitution is used in OpenACS, see e.g. https://openacs.org/forums/message-view?message_id=544436
Sooner or later, we should address this.