citext contrib module (building indexes) - Mailing list pgsql-general

From Michael Gould
Subject citext contrib module (building indexes)
Date
Msg-id 99cb349b00adff21a0bad062128d360d@intermodalsoftwaresolutions.net
Whole thread Raw
In response to Re: A question on PSQL 8.3 setup  (Jong Chun Park <joumon@gmail.com>)
List pgsql-general

I've got several columns in my database that need to have case insensitive searches done so I've loaded the citext control module and have changed the data types to citext.  When I create a index on a column that is defined as a citext, how is that going to be treated.  Will Postgres use the index to search or will it always do a table scan?

 

Best Regards


Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: user/grant - best practices handling permission in production system
Next
From: Tim Uckun
Date:
Subject: A question about pg_standby.