Re: Use a view as opposed to a table and it doesn't work!

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Use a view as opposed to a table and it doesn't work!
Дата
Msg-id 2296.974829953@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Use a view as opposed to a table and it doesn't work!  (pgsql-bugs@postgresql.org)
Список pgsql-bugs
Дерево обсуждения 
pgsql-bugs@postgresql.org writes:
> Use a view as opposed to a table and it doesn't work!

This is a longstanding limitation in Postgres views.  You can't do
multiple levels of aggregation in a single query, and a view does
not get you past that.

It's fixed for 7.1, however.  In current sources I get the expected
answer.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: Use a view as opposed to a table and it doesn't work!
Следующее
От: Theo Kramer
Дата:
Сообщение: update on unique constraint