Re: Quota query with decent performance?

From: Troels Arvin <troels(at)arvin(dot)dk>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Quota query with decent performance?
Date: 2003-11-12 09:32:30
Message-ID: pan.2003.11.12.09.32.30.225407@arvin.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, 11 Nov 2003 18:49:31 -0500, Chester Kustarz wrote:

[... cut efficient top-3 youngest query wanted ...]

> select *
> from person
> where age <=
> (select age from person order by age limit 1 offset 2);

Thanks - it works; why didn't I think of that?

--
Greetings from Troels Arvin, Copenhagen, Denmark

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Troels Arvin 2003-11-12 10:57:08 Re: Quota query with decent performance?
Previous Message Tom Lane 2003-11-12 05:17:58 Re: Quota query with decent performance?