DB
FunctionsBasic

Basic

21 Basic functions in the NYXDB native function registry, with signatures, briefs, and measured medians where available.

21 functions in the basic family. Each name links to its page; … marks the variadic argument list (the engine declares no named parameters). A Measured value appears only where a benchmark corpus case joins by name (server-class hardware, median).

FunctionTypeDescriptionMeasured
any(…) → Dynamicaggregate——
any_last(…) → Dynamicaggregate——
any_value(…) → Dynamicaggregate——
arg_max(…) → Dynamicaggregate——
arg_min(…) → Dynamicaggregate——
avg(…) → Float64aggregate—73.8 ns · server-class
avg_if(…) → Float64aggregate——
count(…) → UInt64aggregate——
count_distinct(…) → UInt64aggregate——
count_if(…) → UInt64aggregate——
max(…) → Float64aggregate—88 ns · server-class
max_if(…) → Float64aggregate——
min(…) → Float64aggregate—87.9 ns · server-class
min_if(…) → Float64aggregate——
range_agg(…) → Stringaggregate——
range_intersect_agg(…) → Stringaggregate——
string_agg(…) → Stringaggregate——
sum(…) → Float64aggregate—73.6 ns · server-class
sum_if(…) → Float64aggregate——
uniq(…) → UInt64aggregate——
uniq_exact(…) → UInt64aggregate——

array_zip_unaligned

Combines arrays position-by-position and fills missing positions with null for shorter arrays.

any

any — Basic function (NYXDB native).