looking for an array-extract-item-as-it operator - Mailing list pgsql-hackers

From Peter Krauss
Subject looking for an array-extract-item-as-it operator
Date
Msg-id CAHEREttBhBwya=yNeWrAHBpdystjjfOpqt-+VHTEEv+8EKF7tA@mail.gmail.com
Whole thread Raw
Responses Re: looking for an array-extract-item-as-it operator
List pgsql-hackers
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 array
FROM 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}}.

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: No Issue Tracker - Say it Ain't So!
Next
From: Tom Lane
Date:
Subject: Re: looking for an array-extract-item-as-it operator