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

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) > (?, ?)

            regards, tom lane