Can you provide some more details about the objective of this patch? Or
a link to previous discussion?
Suppose, Greg's patch could be modified to support order OR index scans:
SELECT ... WHERE (c > 10 AND c < 20) OR (c > 100 AND C < 110) ORDER BY c DESC
with plan:
Result
-> Append
-> Backward index scan (c > 100 AND C < 110)
-> Backward index scan (c > 10 AND C < 20)
I suggested a similar patch two years ago:
http://archives.postgresql.org/message-id/45742c51.9020...@sigaev.ru (4-th
point) and subsequent discussion
http://archives.postgresql.org/pgsql-patches/2006-12/msg00029.php
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
