On Tue, Aug 28, 2012 at 9:46 AM, Nicola Cisternino <ncister@xxxxxxxxxx> wrote: > Hi all, > I'm valutating a complex porting of our application based on Sybase > SqlAnywhere on PostgreSQL (I've love it ...) and I'd like to have your > opinion about searching/ordering funcionality. > The problem is about string comparision. > MS Sql server, MySql, SqlAnywhere and other DB engine allow a simple > definition of case sensitive/insensitive behavior using char, varchar and > text field type. > In PostgreSQL I've already tried to use "citext", lower() function (applied > to indexes, too ...), ILIKE an so on ..... but nothing really work as I need > (poor performances ...) !! hm, poor performance? can you elaborate? merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
