NexusDB V3 Manual
Power Function
|
|
NexusDB Manual V3 > SQL Reference > SQL Functions > Numeric Value Functions
|
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"
|
|
© Nexus Database Systems Pty Ltd.