Re: More wacky grouping

James,

> I need to do grouping based on various aggregates, but the way my table
> is set up (it can't change) is making things kind of difficult.

Yeah.   You should track down the previous database designer and break his 
fingers ....

Anyway, you'll need to work through subselects.   That is, subselect each 
datatype from the table as if it were a seperate table and join them, e.g.

FROM (SELECT content, id_customer FROM table1 WHERE id_datatype = 2) tb2,(SELECT content, id_customer FROM table1 WHERE id_datatype = 3) tb3
etc.

Also, since you'll be summing on a text field which is being converted to 
NUMERIC on the fly, expect your query to be slow as molasses.

-- 
-Josh BerkusAglio Database SolutionsSan Francisco