Entrypoint f_sign compatible with UTF-8
Input DOUBLE floatingpoint Output DOUBLE sign of floatingpoint 1 = positive, 0 = 0, -1 = negative
TestSQL SELECT 1 AS ISCORRECT, F_SIGN(3) FROM RDB$DATABASE; SELECT -1 AS ISCORRECT, F_SIGN(-3) FROM RDB$DATABASE; SELECT 0 AS ISCORRECT, F_SIGN(0) FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_SIGN(NULL) FROM RDB$DATABASE;