PI¶

The PI function is used to retrieve the mathematical constant π (pi), which is approximately 3.141592653589793. The function takes no arguments.

Syntax¶

PI()

Examples¶

Let's consider a table named SingleItem with the following schema:

CREATE TABLE SingleItem (id FLOAT);

Insert a row into the SingleItem table:

INSERT INTO SingleItem VALUES (0);

Example 1: Using PI function¶

SELECT PI() as pi FROM SingleItem;

Result:

        pi
----------------
3.141592653589793

Errors¶

The PI function expects no arguments. Providing any arguments will result in an error.

Example 2: Using PI with an argument¶

SELECT PI(0) as pi FROM SingleItem;

Error: Function expects 0 arguments, but 1 was provided.