Syntax

 

<power function> ::=

 

 

Notes

 

The POWER function returns the value of the first argument raised to the power of the second argument.



 

If both arguments are 0, then the result is 1.



 

If the first argument is 0 and the second argument is positive, then the result is 0.



 

If the first argument is negative, then the second argument shall be an exact numeric value with scale 0.



 

The data type of the result is DOUBLE PRECISION.



 

If either of the arguments are null, then the result is null.



 

 

Examples

 

Expression

 

Result

 

POWER( 0, 0 )

1

POWER( 0, 3 )

0

POWER( -2, 3 )

-8

POWER( 2, 3 )

8

 

 


 

Conformance

 

SQL:2003 standard

-

Feature T621 "Enhanced numeric functions"