Postgres Pro
Downloads
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
Msg-id e63jis$28fk$1@news.hub.org
Whole thread Raw
In response to How to use index in case insensitive substing search  ("Andrus" <eetasoft@online.ee>)
List pgsql-general
Tree view 
>    do you have an index on klient (lower(nimi))?

Yes. As I wrote in first message, I created index explicity for this test
sample:

create index nimib2 on firma1.klient(lower(nimi) bpchar_pattern_ops);

Andrus.

pgsql-general by date:

Previous
From: Roman Neuhauser
Date:
Subject: Re: How to use index in case insensitive substing search
Next
From: "Hakan Kocaman"
Date:
Subject: Re: How to use index in case insensitive substing search