I use PostgreSQL 8 and everything works fine with SQLObject. For the  
quotes PostgreSQL support both syntaxes.

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 (\), so for example the same string could be written  
’Dianne\’s horse’.

-fred-


On Jul 25, 2007, at 7:51 AM, Oleg Broytmann wrote:

> Hello.
>
>    Are here Postgres users who haven't switched to PostgreSQL 8.+? The
> problem is that Postgres 8+ changed quoting style from \' to '',  
> and it's
> impossible for SQLObject to support both styles simultaneously, so if
> everyone has upgraded I will change quoting style in the trunk to ''.
>
> 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


-------------------------------------------------------------------------
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