Re: uppercase = lowercase

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, Ken Guest <kguest(at)stockbyte(dot)com>
Cc: Richard Huxton <dev(at)archonet(dot)com>, jose antonio leo <jaleo8(at)storelandia(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: uppercase = lowercase
Date: 2003-02-14 17:56:26
Message-ID: 5.1.0.14.1.20030215015507.0283c530@mbox.jaring.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-02-14 18:36:18 Re: CREATE TABLE with a name derived from a string
Previous Message Dennis Gearon 2003-02-14 17:42:34 Re: uppercase = lowercase