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 по дате отправления
От: Vadim Mikheev
Дата:
От: Vadim Mikheev
Дата:
FAQ