Data Types

The following data types are supported by Opteryx. Click a name for details.

Numeric types

• DECIMAL — DECIMAL
• DOUBLE — DOUBLE
• INTEGER — INTEGER

Temporal types

• DATE — DATE
• TIME — TIME
• TIMESTAMP — TIMESTAMP

Interval types

• INTERVAL — INTERVAL

Text types

• VARCHAR — VARCHAR

Binary types

• BLOB — BLOB

Boolean types

• BOOLEAN — BOOLEAN

Collection types

• ARRAY — ARRAY
• JSONB — JSONB

Vector types

• VECTOR — VECTOR

Null type

• NULL — NULL