Re: SUM()ming a view's column - Mailing list pgsql-general

From Jan Ploski
Subject Re: SUM()ming a view's column
Date
Msg-id 1188385.988224695394.JavaMail.jpl@remotejava
Whole thread Raw
In response to SUM()ming a view's column  (Jan Ploski <jpljpl@gmx.de>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Translations of PostgreSQL: Introduction and Concepts
Next
From: Joel Burton
Date:
Subject: Re: Performance: sql functions v. plpgsql v. plperl