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

# eetasoft@online.ee / 2006-06-06 11:58:26 +0300:
> How to force postgres to use index for the following query (I can change the
> query to equivalent if required)
>
> select nimi from klient where lower(nimi) like 'test%'

    do you have an index on klient (lower(nimi))?

--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991