Subject Re: [firebird-support] UDF - INVL
Author Helen Borrie
At 11:44 AM 13/01/2004 +0000, you wrote:
>It seems that INVL function from fbudf lib that comes with FB1.5 RC8
>win32 is working incorrectly.
>If I do
>"select invl(3, 0) as x from dual", then I get "0" as result
>"select invl(3, 1) as x from dual" gives "3" (Dual is a dummy table
>with one row)
>Back in RC6 this worked correctly, I guess.

Can't confirm what RC6 did as it's gone. But 3 is the correct
result. It's supposed to return the second argument only if the first
argument is null. You haven't provided a null in either case. Both should
return 3.