From: | pete collins <pcollins(at)ocsny(dot)com> |
---|---|
To: | Marcin Grondecki <ojciec(at)mtl(dot)pl> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] trouble with sum |
Date: | 1999-03-19 19:16:45 |
Message-ID: | 36F2A29D.A7667@ocsny.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
=> 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 wrote:
> select sum(p.price), p.product_id, s.sid from ...
> where ...
> group by p.product_id, s.sid
>
> "group by" clause is the key. You cannot use non-aggregate fields
> in question like this, where some fields are aggregates, without grouping
> them.
> Sometimes i'd like to use syntax you presented, but in postgreSQL
> it isn't possible :( And it makes some sense...
>
> At 13:29 99-03-19 -0500, you 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' and P.product_id= S.product_id;
> >
> >i've used similar commands like this one with other engines with no
> >trouble
> >
> >what do i need to do to get it to work with postgre
> >
>
> Marcin Grondecki
> ojciec(at)mtl(dot)pl
> +48(604)468725
> ***** I'm not a complete idiot, some parts are missing...
From | Date | Subject | |
---|---|---|---|
Next Message | Karl DeBisschop | 1999-03-19 19:49:10 | Re: [GENERAL] database-level locking |
Previous Message | Peter Blazso | 1999-03-19 19:07:14 | problems with a view |