"Owen Hartnett" <[EMAIL PROTECTED]> writes: > Such that the final table has additional subtotal rows with the aggregate sum > of the amounts. I'm thinking I can generate two tables and merge them, but is > there an easier way using a fancy Select statement?
Unfortunately the fancy SQL feature you're looking for is ROLLUP which Postgres doesn't support. I think you would have to do ( select id, code, amount from foo where code < 10 union all select null, code, sum(amount) from foo where code < 10 group by code ) order by code, id -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
