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

From: Vivek Khera <vivek(at)khera(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Can EXCEPT Be Used for To Solve This Problem?
Date: 2005-08-25 14:47:19
Message-ID: 6A9A99AA-E7AF-4922-8B79-75A370582E63@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mark R. Dingee 2005-08-25 15:06:40 Re: Can EXCEPT Be Used for To Solve This Problem?
Previous Message Bruno Wolff III 2005-08-25 13:19:58 Re: How this query!