CBRT
Return the cube root of a number.
CBRT(number)
Alternatively, you can use ||/ number
(no parentheses around number
).
premdb=# SELECT CBRT(10);
cbrt
------------------
2.15443469003188
(1 row)
premdb=# SELECT ||/ 10;
?column?
------------------
2.15443469003188
(1 row)
premdb=# SELECT CBRT(seasonid) FROM season;
cbrt
------------------
1
1.25992104989487
1.44224957030741
1.5874010519682
1.7099759466767
1.81712059283214
1.91293118277239
2
2.0800838230519
...
Parent topic:Mathematical Functions