8.2.8 PI

(1) Specification format

scalar-function-PI ::= PI()

To Page Top

(2) Rules

1. The data type of the execution result is the DOUBLE PRECISION type.

2. The NOT NULL constraint does not apply to the value of the execution result (the null value is allowed). In practice, however, this function always returns the value of , never the null value.

To Page Top

(3) Example

Example:

Determine the circumference of the circle whose radius is the value of column C1 in table T1.

SELECT "C1"*2*PI() FROM "T1"

To Page Top