Posted by Roy Harvey on 07/27/06 21:07

Just a thought, but have you considered changing myfunction (or
writing a new version of myfunction) so that the limit is already
applied to the result it returns?

Roy

On Thu, 27 Jul 2006 12:39:34 +0200, Generale Cluster
<alexcarraro@carrarosoftmasters.net> wrote:

>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

[Back to original message]