Re: [GENERAL] trouble with sum - Mailing list pgsql-general

From Marcin Grondecki
Subject Re: [GENERAL] trouble with sum
Date
Msg-id 3.0.6.32.19990319201302.00831190@mtl.pl
Whole thread Raw
In response to Re: [GENERAL] trouble with sum  (pete collins <pcollins@ocsny.com>)
List pgsql-general
Should work :)
In group by you should group by ALL non-aggregate fields,
in this example - s.product_id too.
But in your original question you wrote "where s.product_id=p.product_id",
so one of these fields became redundant.

At 14:16 99-03-19 -0500, pete collins wrote:
>=> select sum(P.price), P.product_id, S.sid, S.product_id from products P,
>shoppers S
>-> where S.sid='0319199910043810.3.0.12'
>-> group by P.product_id, S.sid;
>ERROR:  parser: illegal use of aggregates or non-group column in target list
>
>
>
>no luck
>i wont let me combine sum(P.price) with the other selects
>
>this should work right?
>

Marcin Grondecki
ojciec@mtl.pl
+48(604)468725
***** I'm not a complete idiot, some parts are missing...


pgsql-general by date:

Previous
From: Marcin Grondecki
Date:
Subject: Re: [GENERAL] database-level locking
Next
From: Karl DeBisschop
Date:
Subject: Re: [GENERAL] database-level locking