Re: orderRules() now a bad idea?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: orderRules() now a bad idea?
Дата
Msg-id Pine.LNX.4.44.0210161857560.928-100000@localhost.localdomain
обсуждение исходный текст
Ответ на Re: orderRules() now a bad idea?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: orderRules() now a bad idea?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: Postgresql and multithreading
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: COPY syntax