Re: uppercase = lowercase

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
________________________________________________________________________