Does Lower make indexes useless?

From: "Clemens Eisserer" <linuxhippy(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Does Lower make indexes useless?
Date: 2006-05-05 17:48:05
Message-ID: 194f62550605051048n6cadb63fl3272085ded3d95f1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I am using queries very often which look like "... WHERE
LOWER(field)='..';" to allow case-insensitive search on varchar
columns.

Does this make indexes useless or are there algorythmns which allow
using indexes even in this case?
Are there ways how this could be done in a better way?

Thank you in advance, lg Clemens

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2006-05-05 17:54:32 Re: Does Lower make indexes useless?
Previous Message diego 2006-05-05 12:13:00 rowInserted, rowDeleted and rowUpdated