PostgreSQL/Math Functions/Pow
pow(0) AS "two cubed", pow(0) AS "two squared", pow(0) AS "just two"
postgres=#
postgres=# SELECT pow(2.0, 3.0) AS "two cubed",
postgres-# pow(2.0, 2.0) AS "two squared",
postgres-# pow(2.0, 1.0) AS "just two";
two cubed | two squared | just two
--------------------+--------------------+--------------------
8.0000000000000000 | 4.0000000000000000 | 2.0000000000000000
(1 row)
postgres=#
pow(x, y): Returns value of x to the exponential power of y
postgres=#
postgres=# -- pow(x, y): Returns value of x to the exponential power of y
postgres=# select pow(2.0, 3) AS "two cubed";
two cubed
--------------------
8.0000000000000000
(1 row)
postgres=#