Numeric functions (Exponent and Root)
Returns the square of a numeric expression (i.e. a numeric expression multiplied by itself).
Syntax¶ Usage notes¶Always returns a floating point number, even if the input expression is of an integer type.
More efficient than the expression x*x, so square(x) is preferred when a floating-point result is acceptable.
SELECT column1, square(column1) FROM (values (0), (1), (-2), (3.15), (null)) v; ---------+-----------------+ column1 | square(column1) | ---------+-----------------+ 0 | 0 | 1 | 1 | -2 | 4 | 3.15 | 9.9225 | [NULL] | [NULL] | ---------+-----------------+
Copy
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4