Does anyone know of any plans to support aggregates of aggregates in the future? It would be great to be able to select with an aggregate function from another select statement with another aggregate function. I have tried putting the result of an aggregate function in a view and then performing another aggregate function on the view, but I get the error that nested aggregates are not supported. My solution was to put the result of the first aggregate function in a temp table, then doing the other select statement on the temp table. This is not very efficient as the temp table can have up to a million records in it. Is this feature planned for Postgres? Does anyone know a better workaround than the way I am doing it? Thanks in advance, -Tor
