The subject has been discussed on this mailing list before, recently. To be able to switch from SQL Server to Postgresql, for me this is essential.
Therefore the question: are there plans to create a set of case insensitive, and maybe also accent insensitive collations in the near future? I have no idea how complex this is, but it seems to me, looking at MySQL and SQL Server that it's not such a strange thing to expect from a database server. I know I can use "lower" (even on indexes) and citext, but this feels like patchwork, and would mean a lot of work when converting our database (with 122 tables). Regards, Marcel van Pinxteren