Re: referencing to "computed columns" in where clause

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