From: | chester c young <chestercyoung(at)yahoo(dot)com> |
---|---|
To: | Alexy Khrabrov <deliverable(at)gmail(dot)com> |
Cc: | sql pgsql <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: columns for count histograms of values |
Date: | 2008-04-30 23:12:12 |
Message-ID: | 357171.1486.qm@web54307.mail.re2.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
--- Alexy Khrabrov <deliverable(at)gmail(dot)com> wrote:
> Greetings -- I have a table of the kind
>
> Ratings:
> id integer
> rating smallint
>
> -- where value can take any value in the range 1 to 5. Now I want to
>
> have a statistical table Stats of the form
>
> id integer
> min smallint
> max smallint
> avg real
> r1 integer
> r2 integer
> r3 integer
> r4 integer
> r5 integer
>
> -- how can I create it in one pass over Ratings?
select id, min(rating), max(rating), avg(rating),
sum( case rating = 1 then 1 else 0 end ),
...
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
From | Date | Subject | |
---|---|---|---|
Next Message | Mag Gam | 2008-05-01 01:32:51 | Re: columns for count histograms of values |
Previous Message | Alexy Khrabrov | 2008-04-30 21:01:13 | columns for count histograms of values |