Name

power — return value of expression raised to specified power.

Synopsis

power ( in x double precision ,
  in y double precision );
 

Description

power raises x to the yth power and returns the value as a IEEE 64-bit float.

Parameters

x

double precision

y

double precision

Return Values

power returns a IEEE 64-bit float.

Examples

Example 24.246. Stored Procedure Example

Calculate squares of integers between 2 numbers.

SQL> create procedure
calc_pow2s (in _from integer, in _to integer)
{
  declare i integer;
  declare result double precision;

  result_names (i, result);

  i := _from;
  while (i < _to)
   {
     result (i, power (i, 2));
     i := i + 1;
   }
}
;
Done. -- 5 msec.
SQL> calc_pow2s (1, 10);
i                 result
INTEGER NOT NULL  DOUBLE PRECISION NOT NULL
_______________________________________________________________________________

1                                  1.000000
2                                  4.000000
3                                  9.000000
4                                 16.000000
5                                 25.000000
6                                 36.000000
7                                 49.000000
8                                 64.000000
9                                 81.000000

9 Rows. -- 7 msec.


See Also

log