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

[Mark Mielke <mark@xxxxxxxxxxxxxx>]

Tom Lane wrote:

Mark Mielke <mark@xxxxxxxxxxxxxx> 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@xxxxxxxxx>