Re: Q: How ORDER BY is being done inetrnally?

Поиск
Список
Период
Сортировка
От Nicolai Tufar
Тема Re: Q: How ORDER BY is being done inetrnally?
Дата
Msg-id 000101c3e97a$570149d0$7a00a8c0@ntufar
обсуждение исходный текст
Ответ на Re: Q: How ORDER BY is being done inetrnally?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Q: How ORDER BY is being done inetrnally? - solved  ("Nicolai Tufar" <ntufar@pisem.net>)
Список pgsql-hackers
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
>
>
> Text sorting depends on strcoll() and nothing but.  See varstr_cmp().

I see, apparently sort done for "ORDER BY" clause is case-sensitive.

But problem is still there. It is about "I"-with-dot and "I"-without-dot
in Turkish again. While all UNIX programs put "I"-without-dot before 
"I"-with-dot, as it should be, PostgreSQL puts it in reverse order.

I examine the code for any possible gotchas, but I am confused about
what function is being called by what. Especially that all those sort
methods and functions are not hard-coded but stored in pg_am* catalogue
tables. Could someone please explain -very briefly- what exactly is 
happening when a sort is performed. A kind of stack trace: which
function
calls which one would be very appreciated.

Best regards,
Nicolai Tufar



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Re: Idea about better configuration options for sort memory
Следующее
От: Jeff
Дата:
Сообщение: Re: Idea about better configuration options for sort