Postgres Pro
Downloads
Home   >   mailing lists

Re: Can EXCEPT Be Used for To Solve This Problem? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Can EXCEPT Be Used for To Solve This Problem?
Date
Msg-id 10454.1124925663@sss.pgh.pa.us
Whole thread Raw
In response to Can EXCEPT Be Used for To Solve This Problem?  ("Lane Van Ingen" <lvaningen@esncc.com>)
List pgsql-sql
Tree view 
"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

pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Can EXCEPT Be Used for To Solve This Problem?
Next
From: Michael Fuhr
Date:
Subject: Re: Can EXCEPT Be Used for To Solve This Problem?