Re: Combining two bitmap scans out performs a single regular index scan?

Tom Lane wrote:

Mark Mielke <mark@mark.mielke.cc> writes: 

To find records after a certain time, I must do one of:   select * from icpric where audtdate > ? or (audtdate = ? and 
audttime > ?)   

In recent releases (at least 8.2, don't remember about 8.1), a row
comparison is what you want:
WHERE (auddate, adttime) > (?, ?) 

Cool! That's the ticket. :-)

I guess it would be unnecessary to translate the other two queries into this one for the purpose of planning, eh? :-)

Cheers,
mark

-- 
Mark Mielke <mark@mielke.cc>