Re: Does anybody use ORDER BY x USING y?

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Does anybody use ORDER BY x USING y?
Дата
Msg-id 87vf0xq601.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: Does anybody use ORDER BY x USING y?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Does anybody use ORDER BY x USING y?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> Hannu Krosing <hannu@skype.net> writes:
> > I think that placement of NULL's should be a property of ORDER BY and
> > separated from opclass.
> 
> That would be an extremely bad idea, because it would immediately remove
> index scans as one way to meet an ORDER BY.  

Well couldn't the index scan be taught to go fetch the NULLs in a separate
traversal? 

-- 
greg



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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Does anybody use ORDER BY x USING y?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Does anybody use ORDER BY x USING y?