Tim, It is my understanding that since the extention citext is available that this gives you what your asking for and at least at this point isn't going to be part of the core. Michael Gould Intermodal Software Solutions, LLC 904-226-0978 -------- Original Message -------- Subject: Re: full text search and ILIKE type clauses. From: Tim Uckun <timuckun@xxxxxxxxx> Date: Mon, March 12, 2012 1:20 pm To: mgould@xxxxxxxxxxxxxxxxxxxx Cc: Tom Lane <tgl@xxxxxxxxxxxxx>, pgsql-general <pgsql-general@xxxxxxxxxxxxxx> > > 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
