Home > mailing lists

Re: How to use index in case insensitive substing search - Mailing list pgsql-general

From	Andrus
Subject	Re: How to use index in case insensitive substing search
Date	June 6, 2006 14:07:10
Msg-id	e6425q$1usk$1@news.hub.org Whole thread Raw
In response to	Re: How to use index in case insensitive substing search ("Hakan Kocaman" <Hakan.Kocaman@digame.de>)
List	pgsql-general

> how about:
> create index nimib2 on firma1.klient(lower(nimi) varchar_pattern_ops);
> ^^^

Hakan, thank you.
Excellent.
It works.

Andrus.

From: Tom Lane
Date: 06 June 2006, 13:55:29
Subject: Re: 7.3.3, Fedora Core 5, test geometry and test horology

From: Tom Lane
Date: 06 June 2006, 14:07:49
Subject: Re: ALTER USER ..... PASSWORD ....