From: | Ragnar Hafstað <gnari(at)simnet(dot)is> |
---|---|
To: | phil campaigne <pcampaigne(at)charter(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Problems with select statement |
Date: | 2005-02-20 21:55:04 |
Message-ID: | 1108936504.10462.80.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, 2005-02-20 at 16:32 -0500, phil campaigne wrote:
> hardwoodthunder=# select player_number, player_name, cum_score, (select
> player_points where aspect='A') as A ,(select player_points where
> aspect='C') as C, (select player_points where aspect='T') as T from
> (select * from player as a,teamshare as b where
> a.player_number=b.player) as c;
>
> player_number | player_name | cum_score | a | c | t
> ---------------+-------------+-----------+------+------+-----
> 42 | S. Randolph | 4 | 0.27 | |
> 42 | S. Randolph | 4 | | 0.33 |
> 42 | S. Randolph | 4 | | | 0.8
> 42 | S. Randolph | 2 | 0.54 | |
> 42 | S. Randolph | 2 | | 0.66 |
> 42 | S. Randolph | 2 | | | 0.8
> 40 | R. Perkins | 4 | 0.27 | |
> 40 | R. Perkins | 4 | | 0.33 |
> (8 rows)
>
> How all three (Randolph, 4) rows into one row?
how about simply:
select player_number, player_name, cum_score,sum(a),sum(c),sum(t) from
(select as above...) group by player_number, player_name, cum_score ?
gnari
From | Date | Subject | |
---|---|---|---|
Next Message | Vitaly Belman | 2005-02-20 21:59:26 | Re: Returning 0 rows from a PL/PGSQL |
Previous Message | phil campaigne | 2005-02-20 21:32:39 | Problems with select statement |