Re: Re: Lock up on 7.0.2 involving CREATE FUNCTION/INDEX.. - Mailing list pgsql-general

From Lamar Owen
Subject Re: Re: Lock up on 7.0.2 involving CREATE FUNCTION/INDEX..
Date
Msg-id 399213D5.9692FA50@wgcr.org
Whole thread Raw
In response to Re: Lock up on 7.0.2 involving CREATE FUNCTION/INDEX..  (philip@adhesivemedia.com (Philip Hallstrom))
List pgsql-general
Philip Hallstrom wrote:
> Oh... Duh!!!  Geesh... for some reason I figured it would call the
> "built-in" UPPER, but obviously it won't. ha ha ha.  *sigh*
> My next question then is how to get around this?  I could just rename my
> function but it's nice to leave it UPPER since that is what it does.  Is
> there another function that will uppercase?  Or is there some way to
> call the other UPPER function?  Or something within plpgsql I don't know

Uh, maybe I'm missing something, but, just _why_ do you need a pl/pgsql
function named UPPER that does nothing but call the built-in upper()?
Is there a type mismatch problem I'm not seeing?  Why do you need to do
this?

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

pgsql-general by date:

Previous
From: philip@adhesivemedia.com (Philip Hallstrom)
Date:
Subject: Re: Lock up on 7.0.2 involving CREATE FUNCTION/INDEX..
Next
From: Mike Mascari
Date:
Subject: Re: Re: Lock up on 7.0.2 involving CREATE FUNCTION/INDEX..