Re: More wacky grouping

James Taylor wrote:
> So, say I wanted to do a sum function, it would end up with something
> like:
>
> Company | Sum
> -------------------
> Globochem | 1130.84
> Toxichem | 1239.47
>

Same crosstab function mentioned the other day:

select company, sum(acct_bal) as "sum" from (select name, company,
acct_bal from crosstab('select id_customer, id_datatype, content from
mytable order by 1','select distinct id_datatype from mytable') as
(id_customer int, name text, company text, acct_bal numeric)) as ss
group by company;
company | sum
-----------+---------
Toxichem | 1239.47
Globochem | 1130.84
(2 rows)

HTH,

Joe