Home > mailing lists

Re: Case sensitivity - Mailing list pgsql-general

From	Frank Millman
Subject	Re: Case sensitivity
Date	August 10, 2005 13:07:26
Msg-id	VPOP32.1.0e.20050810150648.890.c.1.a40c1f81@chagford.com Whole thread Raw
In response to	Re: Case sensitivity (Richard Huxton <dev@archonet.com>)
List	pgsql-general

Tree view

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

pgsql-general by date:

From: "Frank Millman"
Date: 10 August 2005, 11:22:40
Subject: Re: Case sensitivity

From: babu
Date: 10 August 2005, 13:10:02
Subject: pgsql and php with ssl mode.

Re: Case sensitivity - Mailing list pgsql-general

Previous

Next