meta data for this page
  •  

F_SIGN

input/output-compatibility to ib_udf

input/output-compatibility to rFunc (SIGN)

Entrypoint f_sign compatible with UTF-8

Inputs/Outputs

   Input      DOUBLE     floatingpoint
   Output     DOUBLE     sign of  floatingpoint 1 = positive, 0 = 0, -1 = negative

Syntax

   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;