8.2.8 PI
Returns the value of .
- Organization of this subsection
(1) Specification format
scalar-function-PI ::= PI()
(2) Rules
-
The data type of the execution result is the DOUBLE PRECISION type.
-
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.
(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"