Re:PostgreSQL 9.0b1 with built-in replication support
by russss on Monday May 03, 2010 @02:53PM
(#1315674)
The pg_collkey extension gives you access to ICU's unicode collation functionality from within Postgres:
http://www.flexiguided.de/publications.pgcollkey.en.html
Also see my blog post about it here:
Re:PostgreSQL 9.0b1 with built-in replication support
by eds on Monday May 03, 2010 @01:39PM
(#1315399)
Have you tried adding a function that converts between locales and ordering/indexing by that in Postgres?
Like in this thread: http://archives.postgresql.org/pgsql-hackers/2004-09/msg0075...
Earlier, this was specified at cluster initialization time (initdb), then it was one a database level (create database), but what I would really like to see is being able to specify it on query time or, failing that, I would at least like to be able to create multiple indexes with different locales and use those to sort the data.
In the application in question I have to do all sorting on the client side now which also means that pagination needs to be done on the client side which is a huge networking overhead between database and application as I'm fetching rows, sorting them and then throwing away the majority of them.
Aside of that, I love, love, love PostgreSQL ever since I switched from MySQL back in 2000. Every new release was such a pleasure to try out and every time I was happily integrating all newly gained features in my applications.