Re: missing function? - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: missing function?
Date
Msg-id 20041127174237.GA7610@winnie.fuhr.org
Whole thread Raw
In response to missing function?  ("Keith Worthington" <keithw@narrowpathinc.com>)
Responses Re: missing function?  ("Keith Worthington" <keithw@narrowpathinc.com>)
List pgsql-novice
On Sat, Nov 27, 2004 at 12:25:21PM -0500, Keith Worthington wrote:

> We just started to play with the 8.0.0 Beta and can't seem to find the
> function lower() which we used in our where clauses to lower case text.  Can
> anyone explain where it can be found.

What do you mean "can't seem to find"?  What error or unexpected
results are you getting?  What happens when you execute the following
statement?

SELECT lower('ABC');

If that works but another query doesn't, then please post the
simplest possible example that demonstrates the problem.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-novice by date:

Previous
From: Michael Guerin
Date:
Subject: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index"
Next
From: "Wayne T. Carnall"
Date:
Subject: Front end suggestions??