Expand description
Static argument type specifications for all built-in functions.
Each constant defines the accepted argument types per position.
An empty accepted slice means any type is accepted (wildcard).
variadic: true on the last entry means the argument repeats.
Statics§
- APPROX_
COUNT_ ARGS - APPROX_
COUNT_ DISTINCT_ ARGS - APPROX_
PERCENTILE_ ARGS - APPROX_
TOPK_ ARGS - ARRAY_
AGG_ ARGS - ARRAY_
ELEMENTWISE_ ARGS - ARRAY_
MAINT_ ARGS - ARRAY_
PROJECT_ ARGS - ARRAY_
SLICE_ ARGS - AVG_
ARGS - BM25_
SCORE_ ARGS - COALESCE_
ARGS - CONCAT_
ARGS - COUNT_
ARGS - count(*) / count(expr)
- DOC_
ARRAY_ CONTAINS_ ARGS - DOC_
EXISTS_ ARGS - DOC_
GET_ ARGS - FIRST_
LAST_ VALUE_ ARGS - GRAPH_
SCORE_ ARGS graph_score(node_id_col, seed_id, depth => N, label => 'edge_label').- GROUPING_
ARGS GROUPING(col [, col2, ...])— accepts 1 or more column references.- H3_
CELLTOLATLNG_ ARGS - H3_
LATLNGTOCELL_ ARGS - JSON_
EXISTS_ ARGS - JSON_
QUERY_ ARGS - JSON_
VALUE_ ARGS - LAG_
LEAD_ ARGS - LENGTH_
ARGS - MAKE_
ARRAY_ ARGS - MATH_
1_ ARGS - MAX_
ARGS - MIN_
ARGS - MULTI_
VECTOR_ SCORE_ ARGS - MULTI_
VECTOR_ SEARCH_ ARGS - NAV_
ARGS - NDB_
CHUNK_ TEXT_ ARGS - NO_ARGS
- NTH_
VALUE_ ARGS - NTILE_
ARGS - NULLIF_
ARGS - PG_
FTS_ MATCH_ ARGS - PG_
JSON_ 2_ ARGS - PG_
JSON_ BOOL_ 2_ ARGS - PG_
TO_ TSQUERY_ ARGS - PG_
TO_ TSVECTOR_ ARGS - PG_
TS_ HEADLINE_ ARGS - PG_
TS_ RANK_ ARGS - REPLACE_
ARGS - ROUND_
ARGS - RRF_
SCORE_ ARGS - Two-source
rrf_score(rank1, rank2, k1?, k2?)— vector + text. Accepts 2–4 arguments; the planner validates arity at plan time. - RRF_
SCORE_ TRIPLE_ ARGS - Three-source
rrf_score(rank1, rank2, rank3, k1?, k2?, k3?)— vector + text + graph. Shares the same function name; arity dispatch happens in the planner. - SEARCH_
SCORE_ ARGS - SPARSE_
SCORE_ ARGS - SPATIAL_
2_ ARGS - SPATIAL_
3_ ARGS - STRING_
1_ ARGS - ST_
BUFFER_ ARGS - ST_
ENVELOPE_ ARGS - ST_
GEOHASHDECODE_ ARGS - ST_
GEOHASH_ ARGS - ST_
POINT_ ARGS - SUBSTRING_
ARGS - SUM_
ARGS - TEXT_
MATCH_ ARGS - TIME_
BUCKET_ ARGS - TS_
CORRELATE_ ARGS - TS_
EMA_ ARGS - TS_
LAG_ LEAD_ ARGS - TS_
MOVING_ AVG_ ARGS - TS_
PERCENTILE_ ARGS - TS_
STDDEV_ ARGS - TS_
WINDOW_ 1_ ARGS - VECTOR_
DISTANCE_ ARGS