Posted by Generale Cluster on 07/27/06 10:39

Hello,
I need to select the minimum between the result of a function and a
number, but i can't find a smart way. By now I'm doing like the
following, but I think is very expensive because it evaluates the
function twice:

select case when (myfunction())<100 then (myfunction()) else 100 end

Any idea is appreciated.
Thank you
Regards


--
elimina carraro per rispondere via email

[Back to original message]