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
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to