"Lane Van Ingen" <[EMAIL PROTECTED]> writes: > I want to select 2nd oldest transaction from foo (transaction 3).
Can't you just do select * from foo order by update_time desc offset 1 limit 1 regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq