Getting the Root of a Number

[Deleted User]

Jim Knicely authored this tip.

You can find the square root of a number with the |/ operator and the cube root of a number with the ||/ operator.

Example:

dbadmin=> SELECT |/25 square_root_of_25,
dbadmin->        ||/27 cube_root_of_27;
 square_root_of_25 | cube_root_of_27
-------------------+-----------------
                 5 |               3
(1 row)

Have fun!