SQUARE¶
Returns the square value of a numeric expression (x2).
SQUARE(x) is equivalent to POWER(x,2). See POWER.
Syntax¶
SQUARE( expr )
Arguments¶
Parameter |
Description |
|---|---|
|
Numeric expression |
Returns¶
When using the SQUARE floating point number scalar function, real arguments are automatically cast to double precision.
Notes¶
If the value is NULL, the result is NULL.
Examples¶
numbers=> SELECT SQUARE(3);
square
------
9.0