as 14 columns, a category, 12 month numeric columns, and a total numeric column.
The function finds monthly totals for each category (which is the target of "order by")
and the grand total for the specified year.
I have another sql function annual_profit_loss(<year>) that summarizes the total
for each month and the grand total for each year. ( There is a text column that
serves a label.) It generates a summary for the annual_report function in essence.
I have hoped that
select * from annual_report(2003) union select * from annual_profit_loss(2003)
would print the last select last ;( but it inserts the last selection alphabetically into the rows of the annual_report depending on the label field... I suppose I could use a label "zzGrand Totals", but that just does not look right.
Is there any way I can force the last select to appear last?
Jerry
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
