Re: Does Lower make indexes useless?

On Fri, 5 May 2006, Clemens Eisserer wrote:

> 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?
>

This question has nothing to do with Java or JDBC, so this isn't the right
list.  You should try -novice or -general.

http://www.postgresql.org/docs/8.1/static/indexes-expressional.html

Kris Jurka