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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
