> > We made most of our text, varchar columns citext data types so that we > could do case insensitive searches. Is this going to negate most of the > index searches? It appeared to our DBA that it would be easier to use > citext data type then need to use ILIKE instead? >
In the same vein... Does postgres have case insensitive collations yet? Now that 9.1 supports column level collations that would be a really great option for case insensitive queries. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
