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) > (?, ?) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
