Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group