CBRT

Overview

The CBRT() function calculates and returns the cube root of a given number. In mathematical terms, for a number x, its cube root y is determined by the equation y³ = x.

Syntax

The syntax for the CBRT() function is as follows:

CBRT(number)

Where:

• number: This is a required value representing the number for which you want to calculate the cube root. It can be a positive or negative whole number, a decimal, or even an expression that evaluates to a number.

For example, you can use expressions like SELECT CBRT(some_column) from test_table, assuming some_column contains a numeric value.

Return Value:
- It will return NULL if the argument is NULL.
- It will give an error if you input a parameter that is not a numeric type.

Examples

Below are several usage examples of the CBRT() function:

Case #1: Basic Cube Root Calculation

Consider the following example:

  SELECT CBRT(125);

The result of this query will be:

 cbrt 
------
    5

Case #2: Cube Root of a Negative Value

To calculate the cube root of a negative number, use the CBRT() function as shown:

  SELECT CBRT(-125);

The final result is as follows.

 cbrt 
------
   -5

Case #3: Cube Root of Decimal Result

For calculations with decimal numbers, use the CBRT() function as demonstrated below:

SELECT CBRT(32);

The result will be a decimal value, as shown below:

       cbrt        
-------------------
 3.174802103936399

Case #4: Cube Root of Decimal Input

In this scenario, fractional seconds are incorporated into the argument:

SELECT CBRT(0.12815);

The result will be the cube root of the provided decimal value.

    cbrt    
------------
 0.50416523

Case #5: Handling Incorrect Argument

When a non-numeric argument is provided, the CBRT() function works as follows:

SELECT CBRT('abc');

An error will be generated, and the result will not be valid.

invalid input syntax for type double precision: "abc"

Case #6: CBRT Operator (||/(x))

Here’s an example using the CBRT operator (||/(x)) to calculate the cube root of a given number:

SELECT ||/(1728) AS cbrt_operator;

In this example, we calculate the cube root of 1728 using the CBRT operator. The result of this query will be:

   cbrt_operator    
--------------------
 12.000000000000002