Array Functions
Array Reversal
arrayReverseInt
Description: Reverses the order of elements in an integer array.
Syntax: arrayReverseInt(int_array)
Example:
SELECT arrayReverseInt(ARRAY[1, 2, 3, 4, 5]);
-- Result: [5, 4, 3, 2, 1]arrayReverseString
Description: Reverses the order of elements in a string array.
Syntax: arrayReverseString(string_array)
Example:
SELECT arrayReverseString(ARRAY['apple', 'banana', 'cherry']);
-- Result: ['cherry', 'banana', 'apple']Array Sorting
arraySortInt
Description: Sorts an integer array in ascending order.
Syntax: arraySortInt(int_array)
Example:
SELECT arraySortInt(ARRAY[4, 1, 3, 5, 2]);
-- Result: [1, 2, 3, 4, 5]arraySortString
Description: Sorts a string array lexicographically.
Syntax: arraySortString(string_array)
Example:
Array Index Operations
arrayIndexOfInt
Description: Returns the first 0-based index of an integer value.
Syntax: arrayIndexOfInt(int_array, value)
Example:
arrayIndexOfString
Description: Returns the first 0-based index of a string value.
Syntax: arrayIndexOfString(string_array, value)
Example:
arrayIndexesOfInt
Description: Returns all indices of an integer value.
Syntax: arrayIndexesOfInt(int_array, value)
Example:
arrayIndexesOfLong
Description: Returns all indices of a long value.
Syntax: arrayIndexesOfLong(long_array, value)
Example:
arrayIndexesOfFloat
Description: Returns all indices of a float value.
Syntax: arrayIndexesOfFloat(float_array, value)
Example:
arrayIndexesOfDouble
Description: Returns all indices of a double value.
Syntax: arrayIndexesOfDouble(double_array, value)
Example:
arrayIndexesOfString
Description: Returns all indices of a string value.
Syntax: arrayIndexesOfString(string_array, value)
Example:
Array Intersection
intersectIndices
Description: Returns common indices between two sorted integer arrays.
Syntax: intersectIndices(array1, array2)
Example:
Array Contains
arrayContainsInt
Description: Checks if an integer array contains a value.
Syntax: arrayContainsInt(int_array, value)
Example:
arrayContainsString
Description: Checks if a string array contains a value.
Syntax: arrayContainsString(string_array, value)
Example:
Array Slicing
arraySliceInt
Description: Extracts a subarray (start inclusive, end exclusive).
Syntax: arraySliceInt(int_array, start, end)
Example:
arraySliceString
Description: Extracts a string subarray.
Syntax: arraySliceString(string_array, start, end)
Example:
Array Distinct
arrayDistinctInt
Description: Removes duplicate integers.
Syntax: arrayDistinctInt(int_array)
Example:
arrayDistinctString
Description: Removes duplicate strings.
Syntax: arrayDistinctString(string_array)
Example:
Array Remove
arrayRemoveInt
Description: Removes the first occurrence of an integer.
Syntax: arrayRemoveInt(int_array, value)
Example:
arrayRemoveString
Description: Removes the first occurrence of a string.
Syntax: arrayRemoveString(string_array, value)
Example:
Array Union
arrayUnionInt
Description: Combines two integer arrays with unique values.
Syntax: arrayUnionInt(array1, array2)
Example:
arrayUnionString
Description: Combines two string arrays with unique values.
Syntax: arrayUnionString(array1, array2)
Example:
Array Concatenation
arrayConcatInt
Description: Concatenates two integer arrays.
Syntax: arrayConcatInt(array1, array2)
Example:
arrayConcatLong
Description: Concatenates two long arrays.
Syntax: arrayConcatLong(array1, array2)
Example:
arrayConcatFloat
Description: Concatenates two float arrays.
Syntax: arrayConcatFloat(array1, array2)
Example:
arrayConcatDouble
Description: Concatenates two double arrays.
Syntax: arrayConcatDouble(array1, array2)
Example:
arrayConcatString
Description: Concatenates two string arrays.
Syntax: arrayConcatString(array1, array2)
Example:
Array Element Access
arrayElementAtInt
Description: Returns the 1-indexed integer element.
Syntax: arrayElementAtInt(array, index)
Example:
arrayElementAtLong
Description: Returns the 1-indexed long element.
Syntax: arrayElementAtLong(array, index)
Example:
arrayElementAtFloat
Description: Returns the 1-indexed float element.
Syntax: arrayElementAtFloat(array, index)
Example:
arrayElementAtDouble
Description: Returns the 1-indexed double element.
Syntax: arrayElementAtDouble(array, index)
Example:
arrayElementAtString
Description: Returns the 1-indexed string element.
Syntax: arrayElementAtString(array, index)
Example:
Array Summation
arraySumInt
Description: Sums all integers in an array.
Syntax: arraySumInt(int_array)
Example:
arraySumLong
Description: Sums all longs in an array.
Syntax: arraySumLong(long_array)
Example:
Array Construction
arrayValueConstructor
Description: Constructs an array from elements.
Syntax: array(element1, element2, ...)
Example:
Array Generation
generateIntArray
Description: Generates an integer sequence.
Syntax: generateIntArray(start, end, increment)
Example:
generateLongArray
Description: Generates a long sequence.
Syntax: generateLongArray(start, end, increment)
Example:
generateFloatArray
Description: Generates a float sequence.
Syntax: generateFloatArray(start, end, increment)
Example:
generateDoubleArray
Description: Generates a double sequence.
Syntax: generateDoubleArray(start, end, increment)
Example:
String Conversion
arrayToString (2-argument)
Description: Joins elements with a delimiter.
Syntax: arrayToString(string_array, delimiter)
Example:
arrayToString (3-argument)
Description: Joins elements with null replacement.
Syntax: arrayToString(string_array, delimiter, nullString)
Example:
Was this helpful?