2010/11/16 marcin mank <marcin.m...@gmail.com>: >> I can only look at the locales that the operating system provides. We >> could conceivably make some simplifications like stripping off the >> ".utf8", but then how far do we go and where do we stop? Locale names >> on Windows look different too. But in general, how do you suppose we >> should map an operating system locale name to an "acceptable" SQL >> identifier? You might hope, for example, that we could look through the > > It would be nice if we could have some mapping of locale names bult > in, so one doesn`t have to write alternative sql depending on DB > server OS:
+1 Pavel > select * from tab order by foo collate "Polish, Poland" > select * from tab order by foo collate "pl_PL.UTF-8" > > (that`s how it works now, correct?) > > Greetings > Marcin Mańk > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers