Re: referencing to "computed columns" in where clause

[Sam Mason <sam(at)samason(dot)me(dot)uk>]

On Tue, Jan 29, 2008 at 06:04:48PM +0100, Ivan Sergio Borgonovo wrote:
> select
>   case
>     when (a>3) then a*b
>     when (a<3) then a+b
>   end as pippo
> where pippo<12;

I've tended to do:

  SELECT *
  FROM (
    SELECT "complicated expression" AS pippo) x
  WHERE pippo  < 12;
 

  Sam