On Thursday 11 January 2007 15:03, Adam Rich wrote:
> How about this?
>
> select item, very_expensive_function(item) as exp, cheap
> from ( Select item, cheap_function(item) as cheap
> From atable where cheap_function(item) > 0 ) sub
> where very_expensive_function(item) > 0
>
>
Well, there is nothing wrong with the much simpler
where cheap_function(item) > 0 and where very_expensive_function(item) > 0.
It's all about the order of evaluation.
Thanks,
Han Holl