Re: Case Insensitive Data Type - Mailing list pgsql-general

From Neil Conway
Subject Re: Case Insensitive Data Type
Date
Msg-id 20020524150022.4701cc2b.nconway@klamath.dyndns.org
Whole thread Raw
In response to Re: Case Insensitive Data Type  ("Russell Black" <russell.black@iarchives.com>)
Responses Re: Case Insensitive Data Type
List pgsql-general
On Fri, 24 May 2002 11:08:34 -0600
"Russell Black" <russell.black@iarchives.com> wrote:
> The EJB container does it for me, and it wants to do a
> SELECT * FROM t1 WHERE f1 = 'whatever';
> Instead of
> SELECT * FROM t1 WHERE lower( f1 ) = 'whatever';

You could have it run the SELECT on a view, where the relevant
column is defined using lower() on the appropriate column
of the real table.

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Efficiency question: VARCHAR with empty string vs NULL
Next
From: Gregory Seidman
Date:
Subject: Re: Question on crypt password