Hi Group,

I have a question about the mod function in ib_udf.dll

From ib_udf.sql:

*
* m o d
*
*****************************************
*
* Functional description:
* Returns the remainder part of the
* division of the two input parameters.
*
*****************************************/
DECLARE EXTERNAL FUNCTION mod
INTEGER, INTEGER
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'IB_UDF_mod' MODULE_NAME 'ib_udf';



Now why on earth does this function return a double? Unless this does
something different to every mod function I have ever used, it wont
return anything that is not an integer.

Was it simply a monday morning when this code was written and now we
are stuck with it for legacy reasons, or is it going to do something
funny if I cast it as an integer?

Thanks in advance:

Adam