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
|
Список | 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 по дате отправления: