Re: [SQLObject] Postgres 7, anyone?

[Oleg B. <ph...@ph...>]

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/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.