Re: LIMIT and SUBQUERIES

Поиск
Список
Период
Сортировка
От Christoph Haller
Тема Re: LIMIT and SUBQUERIES
Дата
Msg-id 3E65FA8B.352136E@rodos.fzk.de
обсуждение исходный текст
Ответ на LIMIT and SUBQUERIES  (cprice@hrdenterprises.com (Chris))
Ответы Re: LIMIT and SUBQUERIES  (Greg Stark <gsstark@mit.edu>)
Список 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 по дате отправления:

Предыдущее
От: Christoph Haller
Дата:
Сообщение: Re: SETOF
Следующее
От: Greg Stark
Дата:
Сообщение: Re: SETOF