Subject Re: [ib-support] What does "NAN" mean where a DOUBLE PRECISION column should be?
Author Frank Ingermann
Hi,

montgomery_list wrote:
> Hi,
>
> This is a really weird error with the return column coming from a new
> UDF...
>
> Best Regards,
>
> David Montgomery

NAN with floating point values means "not a number", that is you get
a combination of bits that don't make up a sensible value. Check
the UDF directly (assuming you have the sources), there seems to be
a little glitch in there (precision mismatch, division by zero or something?)

hth,
fingerman

-------------------------------------------------------------------------
when parsers parse, and compilers compile, then why don't objects object?

fingerbirdy - fingerman's door to Firebird
http://www.fingerbird.de