|
|
Posted by Chris Cheney on 07/27/06 12:35
Generale Cluster <alexcarraro@carrarosoftmasters.net> wrote in news:eaa556
$2nm$1@newsreader.mailgate.org:
> 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
One way, but not necessarily the smartest way:
select min(a) from (select myfunction() a union select 100 a) t
Navigation:
[Reply to this message]
|