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-18 13:24:39
Message-ID: pan.2003.11.18.13.24.38.713364@arvin.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, 18 Nov 2003 06:56:42 -0600, Bruno Wolff III wrote:

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

Thanks; much nicer than my COALESCE-variant.
http://troels.arvin.dk/db/rdbms/#select-top-n-postgresql updated.

--
Greetings from Troels Arvin, Copenhagen, Denmark

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Kishore Thota (kthota) 2003-11-18 13:25:03 type conversion needed
Previous Message Bruno Wolff III 2003-11-18 12:56:42 Re: Quota query with decent performance?