Re: How to use index in case insensitive substing search

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to use index in case insensitive substing search
Date: 2006-06-06 12:15:20
Message-ID: e6425q$1usk$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Hakan, thank you.
Excellent.
It works.

Andrus.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2006-06-06 12:22:43 Re: New version of DBD::Pg for 8.1.4?
Previous Message pobox@verysmall.org 2006-06-06 12:03:28 Re: php 5.1.4 w/ PostgreSQL 8.1.4