Re: Case Insensitive Data Type

On Fri, 24 May 2002 11:08:34 -0600
"Russell Black"  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 
PGP Key ID: DB3C29FC