From: | Ken Guest <kguest(at)stockbyte(dot)com> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | jose antonio leo <jaleo8(at)storelandia(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: uppercase = lowercase |
Date: | 2003-02-14 11:20:33 |
Message-ID: | 3E4CD101.6080906@stockbyte.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Richard Huxton wrote:
>On Friday 14 Feb 2003 8:51 am, jose antonio leo wrote:
>
>
>>Hi!!
>>
>>How can I make selects not sensitive uppercase and lowercase characters?
>>This is possible modifying something of psql configuration?
>>
>>
>
>This isn't possible in a general way. If you want "Richard","RICHARD" and
>"riCHard" to all test the same you'll need to do something like.
>
>SELECT * FROM people WHERE lower(first_name)='richard';
>
>You can create an index on lower(first_name) if you need to speed things
>along.
>
I thought you could only create indices on fields - not on the results
of operations on those fields.
Is it truly possible to create an index on lets say upper(last_name)?
k.
________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________
From | Date | Subject | |
---|---|---|---|
Next Message | Pablo Varasa | 2003-02-14 11:39:06 | db "hot switch" |
Previous Message | Andreas Rust | 2003-02-14 10:58:00 | Postgres Databases growing without much reason |