Skip to content

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