Re: [SQLObject] Postgres 7, anyone?

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

On Wed, Jul 25, 2007 at 09:13:22AM -0700, Fred C wrote:
> Why not change SQLObject to used '' instead of \' since it is the SQL
> standard way to write a single quote.

   This is exactly what I want to do. I thought PostgreSQL before 8.0
didn't support '' style quoting but I was wrong, even Pg 7.3 supports it:

http://www.postgresql.org/docs/7.3/static/sql-syntax.html

   "SQL allows single quotes to be embedded in strings by typing two
adjacent single quotes (e.g., 'Dianne''s horse'). In PostgreSQL single
quotes may alternatively be escaped with a backslash ("\", e.g., 'Dianne\'s
horse')."

   That closes the issue. Thank you for forcing me to look into the docs! ;)

Oleg.
--
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.