Right now I am using 8.2 on FreeBSD.

postgresql-client-8.2.4 PostgreSQL database (client)
postgresql-server-8.2.4_1 The most advanced open-source database  
available anywhere

-fred-

On Jul 25, 2007, at 8:29 AM, Oleg Broytmann wrote:

> 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