postgres.git / summary / log / commit / refs

commit    e7fe89d57ddda6ad35c68bfcf1d78c2fe0caac4e
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Sun Jul 27 03:16:20 2003 +0000
First released in: 7.4

    This makes the initcap function compatible with Oracle 9i, it has been
    tested on both redhat 8 and FreebSD.
    --
    Mike Nolan


 src/backend/utils/adt/oracle_compat.c | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

diff --git a/src/backend/utils/adt/oracle_compat.c b/src/backend/utils/adt/oracle_compat.c
index 54730ded796..5cfc215d713 100644
--- a/src/backend/utils/adt/oracle_compat.c
+++ b/src/backend/utils/adt/oracle_compat.c
@@ -9,7 +9,7 @@
  *
  *
  * IDENTIFICATION
- *	$Header: /cvsroot/pgsql/src/backend/utils/adt/oracle_compat.c,v 1.44 2003/05/23 22:33:20 tgl Exp $
+ *	$Header: /cvsroot/pgsql/src/backend/utils/adt/oracle_compat.c,v 1.45 2003/07/27 03:16:20 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -132,7 +132,8 @@ initcap(PG_FUNCTION_ARGS)
 
 	while (m-- > 0)
 	{
-		if (isspace((unsigned char) ptr[-1]))
+		/* Oracle capitalizes after all non-alphanumeric */
+		if (!isalnum((unsigned char) ptr[-1]))
 			*ptr = toupper((unsigned char) *ptr);
 		else
 			*ptr = tolower((unsigned char) *ptr);


[parent: 1e5a16cc9ccf]