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: (view raw or whole thread)
Lists: pgsql-jdbc

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 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-2015 The PostgreSQL Global Development Group