POW

All functions > MATH > POW

Returns the value of a number raised to the power of another number.

Signatures

Returns: the value of the base raised to the power of the exponent

POW(base: T, exponent: T) → T

Notes

• POW(x, 0) = 1 for any non-zero x
• POW(0, y) = 0 for positive y
• POW(1, y) = 1 for any y
• Returns NULL if either input is NULL
• Can result in very large or very small numbers
• For negative bases with fractional exponents, result may be complex
• Operator form: base ^ exponent
• Alias: POWER(base, exponent)

Aliases

• POWER

See also

• Operators

Examples

SELECT
    f1 := POW(2, 3),  -- 2 to the power of 3
    f2 := POW(5, 2),  -- 5 squared
    f3 := POW(10, 0),  -- Any number to power 0 is 1
    f4 := POW(2.0e0, -2.0e0),  -- Negative exponent
    f5 := POW(4.0e0, 0.5e0)  -- Square root via power
;