Re: Problem with group by in conjuction with Views

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problem with group by in conjuction with Views
Дата
Msg-id 22488.985882383@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Problem with group by in conjuction with Views  (Jeroen Eitjes <Eitjes@WalRas.nl>)
Список pgsql-hackers
Дерево обсуждения 
Jeroen Eitjes <Eitjes@WalRas.nl> writes:
> I have found a small but annoying bug. I have created a view. The
> SQL-statement in the view contains a GROUP BY statement. Then I compose a
> SQL-statement using this view and another GROUP BY statement and a COUNT(*)
> statement.

This sort of thing will not work at all in Postgres releases earlier
than 7.1.  Sorry.
        regards, tom lane

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

Предыдущее
От: Dirk Lutzebaeck
Дата:
Сообщение: INSERT/SELECT with ORDER BY and LIMIT in 7.1?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Re: Changing the default value of an inherited column