On Wed, Jul 25, 2007 at 08:22:34AM -0700, Fred C wrote:
> I use PostgreSQL 8 and everything works fine with SQLObject. For the
> quotes PostgreSQL support both syntaxes.
8.2? 8.3?
> This is from the reference manual.
>
> 4.1.2.1. String Constants
"A string constant in SQL is an arbitrary sequence of characters bounded
by single quotes ('), for example 'This is a string'. The
standard-compliant way of writing a single-quote character within a string
constant is to write two adjacent single quotes, e.g. 'Dianne''s horse'.
PostgreSQL also allows single quotes to be escaped with a backslash (\').
HOWEVER, FUTURE VERSIONS OF POSTGRESQL WILL NOT ALLOW THIS"
(Uppercased by me.)
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss