Re: Per-column collation - Mailing list pgsql-hackers

From marcin mank
Subject Re: Per-column collation
Date
Msg-id AANLkTi=D1t4cJhmPXNGyWUUKKsK6U9gJFMTDCr_GE1ah@mail.gmail.com
Whole thread Raw
In response to Re: Per-column collation  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Per-column collation
Re: Per-column collation
List pgsql-hackers
> 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:
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


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Per-column collation
Next
From: Robert Haas
Date:
Subject: Re: Explain analyze getrusage tracking