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

expr

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