Mega Code Archive

 

Categories / PostgreSQL / Math Functions

 

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=#