Skip site navigation (1) Skip section navigation (2)

Case Insensitive searches

From: "Mike Gould" <mgould(at)allcoast(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Case Insensitive searches
Date: 2008-08-04 13:54:38
Message-ID: 20080804135438.1a0de37e@mail.allcoast.net (view raw or flat)
Thread:
Lists: pgsql-sql
In the application that we are working on, all data searches must be case insensitive.    
   
Select * from test where column1 = 'a' and Select * from test where column1 = 'A' should always be the same and use the index if column1 is indexed.  In order to do this am I going to be required to use the lower() on all selects in order to make sure that they are case insensitive?  In some db's if you use a lower() or upr() it will always do a table scan instead of using a index

Best Regards,

Michael Gould, Manager Information Technology
All Coast Intermodal Services, Inc.
First Coast Intermodal Services, Inc.
First Coast Logistical Services, LLC.
904-226-0978  
   
 

Responses

pgsql-sql by date

Next:From: Tom LaneDate: 2008-08-04 13:59:20
Subject: Re: return setof record - strange behavior
Previous:From: Marcin KrawczykDate: 2008-08-04 11:33:59
Subject: Re: return setof record - strange behavior

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group