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