Re: Case insensitive selects?

Indexes *can* and *will* be used if you create the appropiate
functional indexes, i.e:

CREATE INDEX idx_table_field_upper ON table(upper(field));

SELECT field FROM table WHERE upper(field) LIKE upper('some string');

Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio

On Thu, 15 Feb 2001, Anand Raman wrote:

> Hi
> use it if u absolutly need it.. Using a function on a column name
> doesnt use the index associated with that column,.. So exercise this
> option with some amount of thinking..
>
> Anand
> On Wed, Feb 14, 2001 at 11:39:47AM -0500, Adam Lang wrote:
> >It is in the list archives several times.
> >
> >All you need is to use some basic SQL.
> >
> >select * from mytable where upper('my criteria') = upper(mytable.info);
> >
> >Adam Lang
> >Systems Engineer
> >Rutgers Casualty Insurance Company
> >http://www.rutgersinsurance.com
> >----- Original Message -----
> >From: "David Reid" <dreid(at)jetnet(dot)co(dot)uk>
> >To: <pgsql-general(at)postgresql(dot)org>
> >Sent: Wednesday, February 14, 2001 9:58 AM
> >Subject: [GENERAL] Case insensitive selects?
> >
> >
> >> Does pgsql support this and how would I do it?
> >>
> >> david
>