VERSION()

All functions > METADATA > VERSION()

Returns registry version; reload time is set only on a dev workstation.

Signatures

Returns: Registry version; reloaded_at is set on a dev workstation only

VERSION()ROW(version VARCHAR, reloaded_at VARCHAR)
sql
ParameterTypeRequiredDescription

Notes

  • Always returns a row with version (e.g. 0.2.1)
  • reloaded_at (UTC ISO-8601 worker ready time) is set on a dev workstation only; NULL on hosted tiers
  • Use SELECT VERSION()[version] or SELECT VERSION()[reloaded_at] for single columns
  • reloaded_at changes when the API worker restarts (uvicorn hot reload)
  • Part of the FeatureMesh constant functions

Examples

E/PI/NULL/VERSION/EMPTY and other no-arg constants (4-operators_and_functions.slt)

FeatureQL
SELECT
    E,
    E(),
    PI,
    PI(),
    INFINITY,
    INFINITY(),
    NAN,
    NAN(),
    NULL,
    NULL(),
    EMPTY,
    EMPTY()
Result
?_0 DECIMAL?_1 DECIMAL?_2 DECIMAL?_3 DECIMAL?_4 DECIMAL?_5 DECIMAL?_6 DECIMAL?_7 DECIMAL?_8 VARCHAR?_9 VARCHAR?_10 VARCHAR?_11 VARCHAR
2.7182818284590452.7182818284590453.1415926535897933.141592653589793InfinityInfinityNULLNULLNULLNULLEMPTY()EMPTY()