Re: SUM()ming a view's column

From: Jan Ploski <jpljpl(at)gmx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: SUM()ming a view's column
Date: 2001-04-25 18:51:35
Message-ID: 1188385.988224695394.JavaMail.jpl@remotejava
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Apr 25, 2001 at 12:52:15PM -0400, Tom Lane wrote:
> Jan Ploski <jpljpl(at)gmx(dot)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

Browse pgsql-general by date

  From Date Subject
Next Message Alejandro Cicero 2001-04-25 19:25:46 Consulta
Previous Message Bruce Momjian 2001-04-25 18:05:32 Translations of PostgreSQL: Introduction and Concepts