diff options
| author | Marc G. Fournier <scrappy@hub.org> | 1998-01-13 03:49:51 +0000 |
|---|---|---|
| committer | Marc G. Fournier <scrappy@hub.org> | 1998-01-13 03:49:51 +0000 |
| commit | f0445dcbc417f03b79f4502570732924b39e5cc5 (patch) | |
| tree | 71e0183218ba16605f6a94ac17693f142d2d46fd /src/backend/utils/adt/oracle_compat.c | |
| parent | fc7950993d4b6b46d89d5a6ba6d8681add3a4399 (diff) | |
| download | postgresql-f0445dcbc417f03b79f4502570732924b39e5cc5.tar.gz postgresql-f0445dcbc417f03b79f4502570732924b39e5cc5.zip | |
> It seems there is a mistake in substr function:
> then you try get substr, which consists only of last char in string
> you get all string
>
> For example:
> userbase=> select substr('123456', 6,1) ;
> substr
> ------
> 123456
> (1 row)
>
From Edmund Mergl <E.Mergl@bawue.de>
Diffstat (limited to 'src/backend/utils/adt/oracle_compat.c')
| -rw-r--r-- | src/backend/utils/adt/oracle_compat.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/backend/utils/adt/oracle_compat.c b/src/backend/utils/adt/oracle_compat.c index 27216ab3d80..e39c83aa26f 100644 --- a/src/backend/utils/adt/oracle_compat.c +++ b/src/backend/utils/adt/oracle_compat.c @@ -1,7 +1,7 @@ /* * Edmund Mergl <E.Mergl@bawue.de> * - * $Id: oracle_compat.c,v 1.10 1997/09/08 21:48:39 momjian Exp $ + * $Id: oracle_compat.c,v 1.11 1998/01/13 03:49:51 scrappy Exp $ * */ @@ -512,7 +512,7 @@ substr(text *string, int4 m, int4 n) if ((string == (text *) NULL) || (m <= 0) || (n <= 0) || - ((len = VARSIZE(string) - VARHDRSZ - m) <= 0)) + ((len = VARSIZE(string) - VARHDRSZ - m + 1) <= 0)) return string; len = len + 1 < n ? len + 1 : n; |