diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-05-11 19:21:31 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-05-11 19:21:31 +0000 |
| commit | ae6124627bfc8bea554a5010504b372825b82c00 (patch) | |
| tree | 2fc2e1c69f648e80faf39a5af2f6c73675e3c596 | |
| parent | 9083bdd28879ac78ca046352dd2c465f7d45f226 (diff) | |
| download | postgresql-ae6124627bfc8bea554a5010504b372825b82c00.tar.gz postgresql-ae6124627bfc8bea554a5010504b372825b82c00.zip | |
Use SQL standard '' rather than \' for tutorial/sample code.
Backpatch to 8.1.X.
| -rw-r--r-- | src/interfaces/ecpg/test/test1.pgc | 2 | ||||
| -rw-r--r-- | src/tutorial/funcs.source | 6 |
2 files changed, 4 insertions, 4 deletions
diff --git a/src/interfaces/ecpg/test/test1.pgc b/src/interfaces/ecpg/test/test1.pgc index 9f784ac7994..a7dba4711de 100644 --- a/src/interfaces/ecpg/test/test1.pgc +++ b/src/interfaces/ecpg/test/test1.pgc @@ -84,7 +84,7 @@ exec sql end declare section; exec sql execute immediate :command; printf("New tuple got OID = %ld\n", sqlca.sqlerrd[1]); - sprintf(command, "insert into \"Test\" (name, amount, letter) values ('db: \\\'mm\\\'', 2, 't')"); + sprintf(command, "insert into \"Test\" (name, amount, letter) values ('db: ''mm''', 2, 't')"); exec sql execute immediate :command; strcpy(msg, "execute insert 2"); diff --git a/src/tutorial/funcs.source b/src/tutorial/funcs.source index 4dfdf278333..bf342d18106 100644 --- a/src/tutorial/funcs.source +++ b/src/tutorial/funcs.source @@ -6,7 +6,7 @@ -- -- Copyright (c) 1994-5, Regents of the University of California -- --- $PostgreSQL: pgsql/src/tutorial/funcs.source,v 1.7 2003/11/29 22:41:33 pgsql Exp $ +-- $PostgreSQL: pgsql/src/tutorial/funcs.source,v 1.7.6.1 2006/05/11 19:21:31 momjian Exp $ -- --------------------------------------------------------------------------- @@ -76,10 +76,10 @@ WHERE EMP.cubicle ~= '(2,1)'::point; -- columns of EMP. CREATE FUNCTION new_emp() RETURNS EMP - AS 'SELECT \'None\'::text AS name, + AS 'SELECT ''None''::text AS name, 1000 AS salary, 25 AS age, - \'(2,2)\'::point AS cubicle' + ''(2,2)''::point AS cubicle' LANGUAGE 'sql'; -- you can then project a column out of resulting the tuple by using the |