Re: Can EXCEPT Be Used for To Solve This Problem?

"Lane Van Ingen" <lvaningen@esncc.com> 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