Array Functions

Array functions are used to manipulate arrays. BodoSQL supports the following array functions:

• !# sql ARRAY_CAT
• !# sql ARRAY_COMPACT
• !# sql ARRAY_CONSTRUCT
• !# sql ARRAY_CONSTRUCT_COMPACT
• !# sql ARRAY_CONTAINS
• !# sql ARRAY_EXCEPT
• !# sql ARRAY_INTERSECTION
• !# sql ARRAY_POSITION
• !# sql ARRAY_REMOVE
• !# sql ARRAY_REMOVE_AT
• !# sql ARRAY_SIZE
• !# sql ARRAY_SLICE
• !# sql ARRAY_TO_STRING
• !# sql ARRAYS_OVERLAP
• !# sql GET
• !# sql GET_IGNORE_CASE