Commite7fe89d

committed

This makes the initcap function compatible with Oracle 9i, it has been

tested on both redhat 8 and FreebSD.--Mike Nolan

1 parent1e5a16c commite7fe89dCopy full SHA for e7fe89d

File tree

-2

lines changed

-2

lines changed

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -9,7 +9,7 @@`
`9`	`9`	`*`
`10`	`10`	`*`
`11`	`11`	`* IDENTIFICATION`
`12`		`- *$Header: /cvsroot/pgsql/src/backend/utils/adt/oracle_compat.c,v 1.44 2003/05/23 22:33:20tgl Exp $`
	`12`	`+ *$Header: /cvsroot/pgsql/src/backend/utils/adt/oracle_compat.c,v 1.45 2003/07/27 03:16:20momjian Exp $`
`13`	`13`	`*`
`14`	`14`	`*-------------------------------------------------------------------------`
`15`	`15`	`*/`
`@@ -132,7 +132,8 @@ initcap(PG_FUNCTION_ARGS)`
`132`	`132`
`133`	`133`	`while (m-->0)`
`134`	`134`	`{`
`135`		`-if (isspace((unsignedchar)ptr[-1]))`
	`135`	`+/* Oracle capitalizes after all non-alphanumeric */`
	`136`	`+if (!isalnum((unsignedchar)ptr[-1]))`
`136`	`137`	`ptr=toupper((unsignedchar)ptr);`
`137`	`138`	`else`
`138`	`139`	`ptr=tolower((unsignedchar)ptr);`

Comments

(0)