Re: Case sensitivity

From: "Frank Millman" <frank(at)chagford(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Case sensitivity
Date: 2005-08-10 13:05:52
Message-ID: VPOP32.1.0e.20050810150648.890.c.1.a40c1f81@chagford.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Frank Millman wrote:

> 1. Will SELECT WHERE LOWER(colname) = 'a001' use the index, or must I
create a separate index on LOWER(colname)?

Sorry. RTFM. The docs clearly state that this is necessary.

Frank

In response to

Browse pgsql-general by date

  From Date Subject
Next Message babu 2005-08-10 13:09:55 pgsql and php with ssl mode.
Previous Message Frank Millman 2005-08-10 11:18:32 Re: Case sensitivity