SIGN()

Procedural SQL (PSQL) StatementsAggregate Functions

`SIGN()`

Sign or signum

Result type

SMALLINT

Syntax

SIGN (number)

Table 1. `SIGN` Function Parameter
Parameter	Description
number	An expression of a numeric type

Returns the sign of the argument: -1, 0 or 1

number < 0 → -1
number = 0 → 0
number > 0 → 1

`SIN()`

Sine

Result type

DOUBLE PRECISION

Syntax

SIN (angle)

Table 1. `SIN` Function Parameter
Parameter	Description
angle	An angle, in radians

The result is in the range [-1, 1].

See also

[fblangref50-scalarfuncs-asin], [fblangref50-scalarfuncs-cos], [fblangref50-scalarfuncs-cot], [fblangref50-scalarfuncs-tan]