Re: full text search and ILIKE type clauses. - Mailing list pgsql-general

From Tim Uckun
Subject Re: full text search and ILIKE type clauses.
Date
Msg-id CAGuHJrMO_Yyz225PpxDW9ibVUxP9rsuOyjs9dAenHbSocY5Y5A@mail.gmail.com
Whole thread Raw
In response to Re: full text search and ILIKE type clauses.  (<mgould@isstrucksoftware.net>)
List pgsql-general
>
> 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.

pgsql-general by date:

Previous
From: Alexander Reichstadt
Date:
Subject: GROUP BY or alternative means to group
Next
From: Tim Uckun
Date:
Subject: Re: Upgrade questions