power function

The pow function returns the value of the first expression raised to the power of the second expression.

Syntax:

double pow(n2,n1)

Semantics:

• n1, n2: The arguments n1 and n2 are expressions that resolve to numbers.

• return type: double.

  • Returns a NULL value in the following cases:

    • If either of the arguments resolves to a NULL value

    • If either of the arguments does not resolve to a number

  • Returns positive infinity if n2 resolves to positive/negative infinity.

  • Returns positive infinity if n1 resolves to positive infinity and zero if n1 resolves to negative infinity.

Example 1 - power function

SELECT pow(n2,n1) FROM PHtable

Value of n	Value of b	Output
2	4	16.0
2	0	1.0
-0.5	4	0.0625
0.5	-4	16.0