Re: LIMIT and SUBQUERIES

>
> 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