POW()

All functions > MATH > POW()

Returns a number raised to the power of another number.

Signatures

Power

Returns: Base raised to the power of exponent

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

With:

• T : Any numeric type

Signature notes:

• Both arguments must be the same numeric type (both integer or both floating-point)
• POW(x, 0) = 1 for any non-zero x
• POW(0, y) = 0 for positive y
• Returns NULL if either input is NULL
• Alias: POWER

Aliases

• POWER

Related operators

• ^ [exponentiation]

Examples

POW(...)

SELECT
    f1 := POW(2, 3) -- Function call
;

.POW(...) — chained

SELECT
    f1 := (2).POW(3), -- Integer literal: parenthesize for `.POW` on BIGINT
    f2 := 2E0.POW(3E0) -- DOUBLE operands: chain without extra parentheses (same-type floating-point power)
;

Edge cases

SELECT
    f1 := POW(5, 2), -- Square
    f2 := POW(10, 0), -- Exponent zero
    f3 := POW(2.0E0, -2.0E0), -- Negative exponent (DOUBLE)
    f4 := POW(4.0E0, 0.5E0) -- Fractional exponent (DOUBLE)
;