Data types

Goal

Reference for supported AngaraBase data types and type casting rules.

SQL type	Alias	Storage	Notes
`INTEGER`	`INT`, `INT4`	32-bit signed	Primary numeric type
`BIGINT`	`INT8`	64-bit signed	Large counters, IDs
`VARCHAR(n)`	—	Variable-length text	Bounded by `n` characters
`TEXT`	—	Variable-length text	Unbounded text
`BOOLEAN`	`BOOL`	1-byte	`TRUE` / `FALSE` / `NULL` (OID 16)
`TIMESTAMP`	—	Text-backed compat	ISO 8601 UTC (OID 1114)
`DATE`	—	Text-backed compat	ISO 8601 date portion (OID 1082)

TIMESTAMP and DATE are stored in text-backed compatibility mode. This means:

Comparisons are performed as text (lexicographical); ISO 8601 format guarantees correct ordering.
Serialization (RM-0.6.5.5): TIMESTAMP is always serialized in UTC without offset (e.g., 2026-05-07 14:30:00.123). Trailing microsecond zeros are truncated.
Arithmetic (INTERVAL etc.) is not supported — 0A000.
BRIN indexes on date / timestamp / timestamptz columns are supported (using text min/max).

SQL type	Status
`DECIMAL` / `NUMERIC`	Planned
`UUID`	Planned

Attempting to use an unsupported type will result in a parser error or 0A000 feature_not_supported.

AngaraBase supports PostgreSQL-syntax type casting:

SELECT '42'::INTEGER;
SELECT id::TEXT FROM t;

Casting between incompatible types results in a runtime error with the corresponding SQLSTATE.