If I had one feature wish free, it would be the option of having an option to sort by multiple locale specific sorting orders in the same database. Earlier, th

If I had one feature wish free, it would be the option of having an option to sort by multiple locale specific sorting orders in the same database. 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.