Controlling order of evaluation?
От | Jerry LeVan |
---|---|
Тема | Controlling order of evaluation? |
Дата | |
Msg-id | 10D50E6D-119C-11D9-B3A8-000393779D9C@eku.edu обсуждение исходный текст |
Ответы |
Re: Controlling order of evaluation?
Re: Controlling order of evaluation? |
Список | pgsql-general |
I have an srf sql function "annual_report(<year>)" that 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
В списке pgsql-general по дате отправления: