Re: Should AT TIME ZONE be volatile? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Should AT TIME ZONE be volatile?
Date
Msg-id b9dea4c1-2f9d-1d92-35fd-1fafc2703d6a@enterprisedb.com
Whole thread Raw
In response to Re: Should AT TIME ZONE be volatile?  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Should AT TIME ZONE be volatile?
List pgsql-hackers
On 11.11.21 18:32, Robert Haas wrote:
> I agree with Tom that it sounds like a lot of work. And to be honest
> it's work that I don't really feel very excited about. It would be
> necessary to understand not only the bona fide sorting rules of every
> human language out there, which might actually be sort of fun at least
> for a while, but also to decide - probably according to some
> incomprehensible standard - how Japanese katakana ought to sort in
> comparison to, say, box-drawing characters, the Mongolian alphabet,
> and smiley-face emojis. I think it's not particularly likely that
> there are a whole lot of documents out there that include all of those
> things, but the comparison algorithm has to return something, and
> probably there are people who have strong feelings about what the
> right answers are. That's a pretty unappealing thing to tackle, and I
> am not volunteering.
> 
> On the other hand, if we don't do it, I'm suspicious that things will
> never get any better. And that would be sad.

There are standards for sort order, and the major hiccups we had in the 
past were mostly moving from older versions of those standards to newer 
versions.  So at some point this should stabilize.




pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Parallel vacuum workers prevent the oldest xmin from advancing
Next
From: Peter Eisentraut
Date:
Subject: Re: Test::More version