>
> 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.