Is is possible, via some clever sql coding ( perhaps with PL/pgsql) to get subtotals to appear in a selection, ie
If I have a query: select * from checks order by category I would like the have the subtotals appear (possibly in an unused column for each "category" when the category "breaks".
Basically I would like to meld the query:
select category, sum(amount) from checks group by category order by category
Into the of the first select.
Thanks,
Jerry
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
