Re: orderRules() now a bad idea? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: orderRules() now a bad idea?
Date
Msg-id Pine.LNX.4.44.0210161857560.928-100000@localhost.localdomain
Whole thread Raw
In response to Re: orderRules() now a bad idea?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: orderRules() now a bad idea?
List pgsql-hackers
Tom Lane writes:

> > But alphabetical?  According to whose definition of the alphabet?
>
> It looks like NAME comparison uses strcmp (actually strncmp).  So it'll
> be numeric byte-code order.
>
> There's no particular reason we couldn't make that be strcoll instead,
> I suppose, except perhaps speed.

But how will this work when we have per-column/datum collation order?
And what about languages that don't have any useful collation order for
their alphabets (far east)?  ISTM that a globally viable feature of this
sort would have to sort by something numeric.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Postgresql and multithreading
Next
From: Peter Eisentraut
Date:
Subject: Re: COPY syntax