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

On Tue, 18 Nov 2003 08:36:27 -0600, Bruno Wolff III wrote:

> The standard syntax is expression is false instead of
> isfalse(expression)

OK, so I guess that a 'better' (closer to standard) version of your query
would be:

SELECT *
FROM pview
WHERE ( age <= (   SELECT age FROM pview   ORDER BY age ASC   LIMIT 1 OFFSET 20       -- 2=n-1 )
) IS NOT FALSE;

-- 
Greetings from Troels Arvin, Copenhagen, Denmark