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