Chester -- awesome! Exactly what the doctor ordered. Just one
syntactic fix needed on 8.3.1:
case when rating=1 then 1 else 0 end
-- etc.
Cheers,
Alexy
On Apr 30, 2008, at 4:12 PM, chester c young wrote:
--- Alexy Khrabrov <[EMAIL PROTECTED]> 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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
