Opteryx Documentation/Docs

Home Docs Learn Blog

Introduction

What is Opteryx When to use Opteryx

Getting Started

Logging in Site tour Load and query data Your first table

Guides

Cloud Warehouse

Accounts & Access

Embedded Engine

Command Line

SQL Language Reference

Introduction to SQL

Statements

Functions

Operators

Data Types

System Variables Virtual Datasets Reserved Words Limits SQL Supported SQL Conformance

Advanced topics

Python Reference

SQLAlchemy dialect Upload client

API Reference

Overview Authentication API Control API Jobs API OData API Upload API

Internals

Engine overview The planner Execution model Rugo file engine Skene file format Draken vector library Draken vector encoding Draken string storage Bytecode expression engine RISC-V support Benchmarking

Roadmap & Guarantees

Compatibility Known limits

Support

Docs/SQL Language Reference/Functions/PI

PI

Mathematical constant π.

Category: Numeric Functions

Syntax

sql

PI()

Returns

FLOAT — Returns the computed result as FLOAT.

Try Opteryx Now

Support Status© 2026 Opteryx, All Rights Reserved