diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2001-10-13 19:16:32 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2001-10-13 19:16:32 +0000 |
| commit | d1c6983899df5b154c203c6f1ddf56914c0bbb30 (patch) | |
| tree | 0fb43f071ab24bb7760e0c9cd2a4f0cf7e46f46e /src | |
| parent | 9ca41c041361426b78134931c1411b772e9a9a75 (diff) | |
| download | postgresql-d1c6983899df5b154c203c6f1ddf56914c0bbb30.tar.gz | |
Fix logic in insert() function.
Diffstat (limited to 'src')
| -rw-r--r-- | src/interfaces/odbc/odbc.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/interfaces/odbc/odbc.sql b/src/interfaces/odbc/odbc.sql index a1973de0b8..c459697d5b 100644 --- a/src/interfaces/odbc/odbc.sql +++ b/src/interfaces/odbc/odbc.sql @@ -1,5 +1,5 @@ -- PostgreSQL catalog extensions for ODBC compatibility --- $Header: /cvsroot/pgsql/src/interfaces/odbc/Attic/odbc.sql,v 1.2 2001/10/09 22:32:33 petere Exp $ +-- $Header: /cvsroot/pgsql/src/interfaces/odbc/Attic/odbc.sql,v 1.3 2001/10/13 19:16:32 petere Exp $ -- ODBC functions are described here: -- <http://msdn.microsoft.com/library/en-us/odbc/htm/odbcscalar_functions.asp> @@ -33,7 +33,7 @@ CREATE OR REPLACE FUNCTION concat(text, text) RETURNS text AS ' -- INSERT(string1, start, len, string2) CREATE OR REPLACE FUNCTION insert(text, integer, integer, text) RETURNS text AS ' - SELECT substring($1 from 1 for $2) || $4 || substring($1 from $2 + $3 + 1); + SELECT substring($1 from 1 for $2 - 1) || $4 || substring($1 from $2 + $3); ' LANGUAGE SQL; |