Re: AW: partial index - Mailing list pgsql-hackers

From Tom Lane
Subject Re: AW: partial index
Date
Msg-id 21912.997114565@sss.pgh.pa.us
Whole thread Raw
In response to Re: AW: partial index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at> writes:
>> Since bid is not in an index the evaluation of usability obviously 
>> should not be based on index ops ?

Actually, now that I think about it, there's no reason that the prover
couldn't try a simple equal() on a WHERE clause and predicate clause
before moving on to the btree-semantics-based tests.  If the clauses
are statically identical then one implies the other, no?  This would
work nicely for clauses like IS [NOT] NULL, and would give us at least a
little bit of ability to deal with non-btree operator clauses.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: failed: make install prefix=/foo/bar
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: Re: AW: Re: OID wraparound: summary and proposal