Re: SUM()ming a view's column

Поиск
Список
Период
Сортировка
От Jan Ploski
Тема Re: SUM()ming a view's column
Дата
Msg-id 1188385.988224695394.JavaMail.jpl@remotejava
обсуждение исходный текст
Ответ на SUM()ming a view's column  (Jan Ploski <jpljpl@gmx.de>)
Список pgsql-general
On Wed, Apr 25, 2001 at 12:52:15PM -0400, Tom Lane wrote:
> Jan Ploski <jpljpl@gmx.de> writes:
> > Here, v_wutest is a view which returns two rows. Shouldn't the SUM
> > aggregate simply add these two values? To me, it looks like a bug.
>
> Does the view contain GROUP BY?  If so, yes this is broken in pre-7.1
> releases ...

Yes, it does. Everything's clear then :-)
Thanks for your reply (and for the fix in 7.1 to whoever deserves credit!)

-JPL


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Translations of PostgreSQL: Introduction and Concepts
Следующее
От: Joel Burton
Дата:
Сообщение: Re: Performance: sql functions v. plpgsql v. plperl