Re: missing function?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Keith Worthington <keithw(at)narrowpathinc(dot)com>
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: missing function?
Date: 2004-11-27 17:42:37
Message-ID: 20041127174237.GA7610@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Antoine 2004-11-27 18:13:41 Re: Front end suggestions??
Previous Message Michael Guerin 2004-11-27 17:41:26 ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index"