Re: Top N within groups? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Top N within groups?
Date
Msg-id 20080711074704.GB11710@svana.org
Whole thread Raw
In response to Top N within groups?  (Klint Gore <kgore4@une.edu.au>)
Responses Re: Top N within groups?
List pgsql-general
On Fri, Jul 11, 2008 at 01:24:28PM +1000, Klint Gore wrote:
> [thinking out loud]
> Can someone familiar with the source for DISTINCT ON comment on how hard
> it would be to add another parameter to return more than one row?

From a programming point of view, it wouldn't be too hard. However,
deciding what syntax to use is a another question entirely. I think
your suggestion of FOR isn't good (ambiguous syntax, 'for' could be a
column name), but I can't think of a better one.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

Attachment

pgsql-general by date:

Previous
From: "Michael Shulman"
Date:
Subject: view row-level locks
Next
From: "Ivan Zolotukhin"
Date:
Subject: Re: storing latitude and longitude