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