citext contrib module (building indexes)

[Michael Gould <mgould@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>]

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