Re: Case sensitivity - Mailing list pgsql-general

From Roman Neuhauser
Subject Re: Case sensitivity
Date
Msg-id 20050810171751.GA7638@isis.sigpipe.cz
Whole thread Raw
In response to Re: Case sensitivity  ("Frank Millman" <frank@chagford.com>)
List pgsql-general
# frank@chagford.com / 2005-08-10 13:18:32 +0200:
> 1. Will SELECT WHERE LOWER(colname) = 'a001' use the index, or must I create
> a separate index on LOWER(colname)?

    the latter

--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991

pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: World-wide Stop Order on PERL,Python,Java::->> Use
Next
From: Roman Neuhauser
Date:
Subject: Re: 5 new entries for FAQ