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: Wed, 12 Nov 2003 11:57:08 +0100
Message-ID: <pan.2003.11.12.10.57.08.335463@arvin.dk> (raw)
References: <pan.2003.11.11.22.58.08.758402@arvin.dk>
	<Pine.BSO.4.44.0311111832190.19584-100000@detroit.arbor.net>

On Tue, 11 Nov 2003 18:49:31 -0500, Chester Kustarz wrote:

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

Integrated into http://troels.arvin.dk/db/rdbms/#select-top-n

-- 
Greetings from Troels Arvin, Copenhagen, Denmark





view thread (13+ messages)  latest in thread

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

 · 

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.12.10.57.08.335463@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