Re: Case insensitive selects?

From: David Wheeler <david(at)wheeler(dot)net>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Michael Fork <mfork(at)toledolink(dot)com>, Anand Raman <araman(at)india-today(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Case insensitive selects?
Date: 2001-02-16 20:05:38
Message-ID: Pine.LNX.4.21.0102161202230.24414-100000@theory
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 16 Feb 2001, Bruce Momjian wrote:

> Yes, our CREATE INDEX lower(col) already does that, but you do have to
> use lower(col) when doing the query.

Right, that's what I'm suggesting a configuration that automates the
lower(col) bit in CREATE INDEX and that automates the lower(col) in
queries.

BTW, I've run into some snags with CREATE INDEX lower(col). First it
wouldn't work because my col was varchar (fixec by creating a new
function) and then because I tried to combine columns:

CREATE UNIQUE INDEX idx_name ON server(lower(col1), col2);

But I see that either they all have to be inside the function or for there
be be no function. Will 7.1 support mixing like this?

Thanks for your prompt responses, Bruce.

David

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2001-02-16 20:05:50 Re: Number of Connections
Previous Message Bruce Momjian 2001-02-16 19:57:35 Re: Case insensitive selects?