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>