Re: LIMIT and SUBQUERIES - Mailing list pgsql-sql

From Christoph Haller
Subject Re: LIMIT and SUBQUERIES
Date
Msg-id 3E65FA8B.352136E@rodos.fzk.de
Whole thread Raw
In response to LIMIT and SUBQUERIES  (cprice@hrdenterprises.com (Chris))
Responses Re: LIMIT and SUBQUERIES  (Greg Stark <gsstark@mit.edu>)
List pgsql-sql
>
> So anyway, I have the query that is working - but it returns all
> records for all owners, when what I really want to do is return the
> top 5 per each owner.
>
I've seen a lot of questions like this on the list before about
filtering
result sets. Within the most replies, people were told to use middleware

stuff like perl, awk, sed, ... to filter out unwanted rows, because SQL
was not intended to do so.
Incidentally, I've seen

http://techdocs.postgresql.org/guides/SetReturningFunctions

Maybe this is more useful than telling you 'use a script'.

Regards, Christoph




pgsql-sql by date:

Previous
From: Christoph Haller
Date:
Subject: Re: SETOF
Next
From: Greg Stark
Date:
Subject: Re: SETOF