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