On Sun, Apr 26, 2015 at 5:02 PM, Bjørn T Johansen wrote: > And my problem is that I am using Norwegian in some tables and when using order by the sort order is not correct for the Norwegian letters.. > So my guestion is if it is possible to get the correct sort order without recreating all my databases or initialize PGSQL? You can enforce the collate used in an ORDER BY clause: SELECT a, b, c FROM tbl WHERE ... ORDER BY a COLLATE "C"; http://www.postgresql.org/docs/devel/static/sql-expressions.html#SQL-SYNTAX-COLLATE-EXPRS Regards, -- Michael -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
