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