From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | nolan(at)celery(dot)tssi(dot)com |
Cc: | pgsql patch list <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: patch for Oracle initcap compatibility |
Date: | 2003-07-27 03:16:38 |
Message-ID: | 200307270316.h6R3Gcb03398@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Patch applied. Thanks.
---------------------------------------------------------------------------
nolan(at)celery(dot)tssi(dot)com wrote:
> This makes the initcap function compatible with Oracle 9i, it has been
> tested on both redhat 8 and FreebSD.
> --
> Mike Nolan
>
> RCS file: /projects/cvsroot/pgsql-server/src/backend/utils/adt/oracle_compat.c,v
> retrieving revision 1.44
> diff -c -r1.44 oracle_compat.c
> *** oracle_compat.c 23 May 2003 22:33:20 -0000 1.44
> --- oracle_compat.c 17 Jul 2003 08:03:41 -0000
> ***************
> *** 132,138 ****
>
> while (m-- > 0)
> {
> ! if (isspace((unsigned char) ptr[-1]))
> *ptr = toupper((unsigned char) *ptr);
> else
> *ptr = tolower((unsigned char) *ptr);
> --- 132,139 ----
>
> while (m-- > 0)
> {
> ! /* Oracle capitalizes after all non-alphanumeric */
> ! if (!isalnum((unsigned char) ptr[-1]))
> *ptr = toupper((unsigned char) *ptr);
> else
> *ptr = tolower((unsigned char) *ptr);
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-07-27 03:34:45 | Re: psql patches for win32 |
Previous Message | Bruce Momjian | 2003-07-27 03:13:32 | Re: An additional foreign key test for regression |