Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: SUM()ming a view's column
Date
Msg-id 29527.988217535@sss.pgh.pa.us
Whole thread Raw
In response to SUM()ming a view's column  (Jan Ploski <jpljpl@gmx.de>)
List pgsql-general
Tree view 
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 ...

            regards, tom lane

pgsql-general by date:

Previous
From: Matthew Hixson
Date:
Subject: Re:
Next
From: jdassen@cistron.nl (J.H.M. Dassen (Ray))
Date:
Subject: Re: indices are crashed after installation of rpm