I am using queries very often which look like "... WHERE
LOWER(field)='..';" to allow case-insensitive search on varchar
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
pgsql-jdbc by date
|Next:||From: Kris Jurka||Date: 2006-05-05 17:54:32|
|Subject: Re: Does Lower make indexes useless?|
|Previous:||From: diego||Date: 2006-05-05 12:13:00|
|Subject: rowInserted, rowDeleted and rowUpdated|