Math Functions PostgreSQL

  1. Home
  2. PostgreSQL
  3. Math Functions
  4. Pow(2 0, 3 0) AS two cubed, pow(2 0, 2 0) AS two squared, pow(2 0, 1 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=#