I need to access an array-item from an array of arrays. Suppose

WITH t AS (SELECT '{{1,2,3},{33,44,55}}'::int[][] as a)SELECT
     a[2],    -- returns null (!), why not works?
     a[2:2],  -- returns array-into-array, not a simple arrayFROM t;


There are a simple function or operator to acess it as it?

Summarizing: I am looking for a  f(a,2)  that returns  {33,44,55}, not
{{33,44,55}}.

Reply via email to