DB
FunctionsArray

array_distinct

Removes duplicate elements from each input array and keeps only the first appearance of every distinct value.

array_distinct(…) → String

Kind · scalar · aggregate

scalar — Removes duplicate elements from each input array and keeps only the first appearance of every distinct value.

aggregate — Collects distinct input values across the group and returns them as an array.

Part of the Array family.

array_dims

Returns a PostgreSQL-style bounds string for arrays handled by NYXDB, using [1:n] for populated arrays.

array_dot_product

Computes the scalar product by multiplying aligned elements and summing all products.