Re: Case sensitivity

From: Roman Neuhauser <neuhauser(at)sigpipe(dot)cz>
To: Frank Millman <frank(at)chagford(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Case sensitivity
Date: 2005-08-10 17:17:51
Message-ID: 20050810171751.GA7638@isis.sigpipe.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

# frank(at)chagford(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2005-08-10 17:30:22 Re: World-wide Stop Order on PERL,Python,Java::->> Use
Previous Message Magnus Hagander 2005-08-10 16:44:27 Re: pgsql and php with windows.