Re: Theory of operation of collation patch

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Theory of operation of collation patch
Date: 2011-03-08 22:55:54
Message-ID: 1299624954.19938.23.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On mån, 2011-03-07 at 19:15 -0500, Tom Lane wrote:
> Or, to put it another way: the properties that define a sort order are
> the sort comparison operator, the collation, the ASC/DESC bit, and the
> NULLS FIRST/LAST bit. Given the way that the SQL committee has
> constructed the language, the operator and the two flag bits are
> attached to the ORDER BY clause, but the collation is a property of
> the expression-to-be-sorted. If we fail to preserve that distinction
> in the internal representation, we're just creating problems for
> ourselves.

You are probably right; it could be simplified.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2011-03-08 22:58:07 Re: Alpha4 release blockers (was Re: wrapping up this CommitFest)
Previous Message Peter Eisentraut 2011-03-08 22:54:57 Re: Theory of operation of collation patch