Обсуждение: Does Lower make indexes useless?

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

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

Sorry for the traffic, I was already subscribed and I was too lazy.

> 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
Perfect, thanks a lot :-)

Thanks again, lg Clemens