Re: Controlling order of evaluation? - Mailing list pgsql-general

From Russell Smith
Subject Re: Controlling order of evaluation?
Date
Msg-id 200409291113.12954.mr-russ@pws.com.au
Whole thread Raw
In response to Controlling order of evaluation?  (Jerry LeVan <jerry.levan@eku.edu>)
List pgsql-general
On Wed, 29 Sep 2004 08:16 am, Jerry LeVan wrote:
> 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)
Order by title_column = 'Grand Total', month

that will put all rows not containing grand total at the top, sorted by month.
Then grand total's sorted by month.  something like that.

>

> 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
>
>

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Foreign key order evaluation
Next
From: Thomas F.O'Connell
Date:
Subject: Indexes on Expressions -- Parentheses