Re: [SQL] Reuse previously calculated column in sql query?

[Rod Taylor]

On Wed, 2004-10-20 at 08:50, Philippe Lang wrote:
> Hello,
> 
> Is it possible to reuse a previously calculated column in a following
> column, like:

SELECT col1
     , col2
     , col2 * 0.75 AS col3
  FROM (SELECT foo.val1 AS col1
             , long_calculation(foo.val1) AS col2
          FROM foo) AS tab;



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html