Skip to content


This document file is generated for functions_set.yaml

Scalar Functions


index_in(needle, haystack, option:nan_equality): -> return_type
0. index_in(any1, list<any1>, option:nan_equality): -> i64?

*Checks the membership of a value in a list of values Returns the first 0-based index value of some input needle if needle is equal to any element in haystack. Returns NULL if not found. If needle is NULL, returns NULL. If needle is NaN: - Returns 0-based index of NaN in input (default) - Returns NULL (if NAN_IS_NOT_NAN is specified) *

  • nan_equality ['NAN_IS_NAN', 'NAN_IS_NOT_NAN']