Re: referencing to "computed columns" in where clause

[Richard Broersma Jr <rabroersma@xxxxxxxxx>]

--- On Tue, 1/29/08, Ivan Sergio Borgonovo <mail@xxxxxxxxxxxxxxx> wrote:

>> other than defining a function such that I can write:

   SELECT ( a-b ) as pippo
     FROM Yourtable
    WHERE ( a-b ) = 7
UNION ALL
   SELECT ( a*b ) as pippo
     FROM Yourtable
    WHERE ( a*b ) < 12
      AND a > 3
UNION ALL
   SELECT ( a+b ) as pippo
     FROM Yourtable
    WHERE ( a+b ) < 12
      AND a < 3;


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend