Use derived expression in select statement

From: "Richard Sydney-Smith" <richard(at)ibisaustralia(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Use derived expression in select statement
Date: 2003-09-14 04:25:58
Message-ID: 000f01c37a78$4ea53560$076c32d2@athlon2000
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I am converting a database from Sybase and have found the following command
does not work in the same fashion.

select dy_c , dy_sect as tsect, (cy_bfwd + dy_p1T4) as curr_bal from fclitot
where dy_yr = 0 and (curr_bal) <-0.005

In the actual command used curr_bal is calculated from a very much longer
expression and rather than repeat the expression I simply refer to it by its
assigned name in sybase.

In postgres it tells me curr_bal is not found. is their a simular shorthand
available in postgres? curr_bal is calc from about 12 fields :{

thanks

Richard

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-09-14 04:38:42 Re: Use derived expression in select statement
Previous Message ow 2003-09-14 01:13:47 A generic trigger?