Re: [HACKERS] OR clause status report - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] OR clause status report
Date
Msg-id 199807311430.KAA24630@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] OR clause status report  (Vadim Mikheev <vadim@krs.ru>)
List pgsql-hackers
> Bruce Momjian wrote:
> >
> > 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;
>
> But did you care about the case when two indices (on test(x) and
> on test(y)) exist ?

Haven't gotten to that yet.

--
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 by date:

Previous
From: Vadim Mikheev
Date:
Subject: Re: AW: [HACKERS] OR clause status report
Next
From: Bruce Momjian
Date:
Subject: Re: AW: [HACKERS] OR clause status report