Re: Does anybody use ORDER BY x USING y? - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Does anybody use ORDER BY x USING y?
Date
Msg-id 87vf0xq601.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Does anybody use ORDER BY x USING y?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Does anybody use ORDER BY x USING y?
List 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 by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Does anybody use ORDER BY x USING y?
Next
From: Tom Lane
Date:
Subject: Re: Does anybody use ORDER BY x USING y?