OR clause status report
От
Bruce Momjian
Тема
OR clause status report
Дата
Msg-id
199807310532.BAA16456@candle.pha.pa.us
Список
Дерево обсуждения
Re: [HACKERS] OR clause status report - working "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Re: [HACKERS] OR clause status report - working Vince Vielhaber <vev@michvhf.com>
I have succeeded in making OR clauses use indexes. I have not dealt with some of the more complex issues like x=3 or y=5 as Vadim mentioned, but at least it works. test=> select * from test where x=102532 or x=102533; x ------ 102532 102533 (2 rows) test=> explain select * from test where x=102532 or x=102533; NOTICE: QUERY PLAN: Index Scan using i_test on test (cost=4.10 size=1 width=4) -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)
В списке pgsql-hackers по дате отправления