|
1 | 1 | -- PostgreSQL catalog extensions for ODBC compatibility |
2 | | --- $Header: /cvsroot/pgsql/src/interfaces/odbc/Attic/odbc.sql,v 1.2 2001/10/09 22:32:33 petere Exp $ |
| 2 | +-- $Header: /cvsroot/pgsql/src/interfaces/odbc/Attic/odbc.sql,v 1.3 2001/10/13 19:16:32 petere Exp $ |
3 | 3 |
|
4 | 4 | -- ODBC functions are described here: |
5 | 5 | -- <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 ' |
33 | 33 |
|
34 | 34 | -- INSERT(string1, start, len, string2) |
35 | 35 | CREATE OR REPLACEFUNCTIONinsert(text,integer,integer,text) RETURNStextAS' |
36 | | - SELECT substring($1 from 1 for $2) || $4 || substring($1 from $2 + $3 + 1); |
| 36 | + SELECT substring($1 from 1 for $2 - 1) || $4 || substring($1 from $2 + $3); |
37 | 37 | ' LANGUAGE SQL; |
38 | 38 |
|
39 | 39 |
|
|