On Aug 24, 2005, at 4:47 PM, Lane Van Ingen wrote:
I want to select 2nd oldest transaction from foo (transaction 3). The
solution below
works, but I think there may be a better way. Does anyone else have
a better
idea?
why not just select order by update_time desc limit 2 then discard
the first row you fetch?
Vivek Khera, Ph.D.
+1-301-869-4449 x806
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
