Re: uppercase = lowercase - Mailing list pgsql-general

At 11:53 AM 2/14/03 +0000, Oliver Elphick wrote:

>On Fri, 2003-02-14 at 11:20, Ken Guest wrote:
> > Is it truly possible to create an index on lets say upper(last_name)?
>
>CREATE INDEX uppername_index ON mytable (upper(last_name));

If you want case insensitivity is it better to do lower or upper? Or it
doesn't matter?

Thanks,
Link.