Re: LIMIT and SUBQUERIES

From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Cc: cprice(at)hrdenterprises(dot)com
Subject: Re: LIMIT and SUBQUERIES
Date: 2003-03-05 13:24:27
Message-ID: 3E65FA8B.352136E@rodos.fzk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Greg Stark 2003-03-05 13:36:29 Re: SETOF
Previous Message Christoph Haller 2003-03-05 13:11:42 Re: SETOF