SELECT
  ARRAY[1, 2, 3, 4, 5] AS int_array,
  ARRAY['a', 'b', 'c'] AS text_array,
  ARRAY_LENGTH(ARRAY[1,2,3], 1) AS arr_length,
  UNNEST(ARRAY['alpha', 'beta', 'gamma']) AS expanded_row,
  3 = ANY(ARRAY[1, 2, 3, 4]) AS element_exists,
  ARRAY[1,2,3] && ARRAY[3,4,5] AS arrays_overlap;