Tom Lane wrote:
> Mark Mielke <mark(at)mark(dot)mielke(dot)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(at)mielke(dot)cc>