Re: Case Insensitive searches

On Mon, Aug 4, 2008 at 6:54 AM, Mike Gould <mgould@allcoast.net> wrote:
>In some db's if you
> use a lower() or upr() it will always do a table scan instead of using a
> index

True, this would also happen in PostgreSQL.  However, you can overcome
this by creating a "functional" index:

http://www.postgresql.org/docs/8.3/interactive/indexes-expressional.html

This way all expression using where lower( column ) = 'a'. will always
use an index scan.


-- 
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug