Re: Quota query with decent performance? - Mailing list pgsql-sql

From Troels Arvin
Subject Re: Quota query with decent performance?
Date
Msg-id pan.2003.11.18.13.24.38.713364@arvin.dk
Whole thread Raw
In response to Quota query with decent performance?  (Troels Arvin <troels@arvin.dk>)
List 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




pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Quota query with decent performance?
Next
From: Troels Arvin
Date:
Subject: Re: Quota query with decent performance?