Subject Re: [firebird-support] UDF - INVL
Author Ivan Prenosil
> 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 anyone confirm this note or am I missing something?

1) No, I can't confirm it. I get "3" in both cases using RC8.

2) You can also read Release Notes:
"The *NVL and *NULLIF functions remain for backward compatibility, but are deprecated by the
introduction of the new internal functions CASE, COALESCE and NULLIF."

Ivan