Re: [GENERAL] [PROPOSAL] DML value format

2007-08-13 Thread Michael Glaesemann
On Aug 13, 2007, at 11:21 , Osvaldo Rosario Kussama wrote: Dollar-Quoted String Constants? http://www.postgresql.org/docs/8.2/interactive/sql-syntax- lexical.html#SQL-SYNTAX-CONSTANTS INSERT INTO persons VALUES ($$Harry$$, $$O'Callaghan$$); Do not interpolate values into SQL literals,

Re: [GENERAL] [PROPOSAL] DML value format

2007-08-10 Thread Michael Glaesemann
On Aug 10, 2007, at 5:56 , Alejandro Torras wrote: Is there some way to put values in a INSERT statement without taking care of apostrophes? In example: INSERT INTO persons VALUES ('Harry', 'O'Callaghan'); This is pretty much a solved problem: don't interpolate into SQL statements. Use

[GENERAL] [PROPOSAL] DML value format

2007-08-10 Thread Alejandro Torras
-- English -- Hi, Is there some way to put values in a INSERT statement without taking care of apostrophes? In example: INSERT INTO persons VALUES ('Harry', 'O'Callaghan'); ^^^ I think that it can be used some kind of length-marker to help the