pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Troels Arvin <troels@arvin.dk>
To: pgsql-sql@postgresql.org
Subject: Re: Quota query with decent performance?
Date: Tue, 18 Nov 2003 14:24:39 +0100
Message-ID: <pan.2003.11.18.13.24.38.713364@arvin.dk> (raw)
References: <pan.2003.11.11.22.58.08.758402@arvin.dk>
	<Pine.BSO.4.44.0311111832190.19584-100000@detroit.arbor.net>
	<pan.2003.11.17.22.55.52.997736@arvin.dk>
	<20031118125642.GC30809@wolff.to>

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

view thread (13+ messages)  latest in thread

Message-ID: <pan.2003.11.18.13.24.38.713364@arvin.dk>
Permalink:  ../pan.2003.11.18.13.24.38.713364@arvin.dk/
Also on:    postgresql.org/message-id/pan.2003.11.18.13.24.38.713364@arvin.dk

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: troels@arvin.dk
  Subject: Re: Quota query with decent performance?
  In-Reply-To: <pan.2003.11.18.13.24.38.713364@arvin.dk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox