Re: [Q] parsing out String array

V S P wrote:
> if I have field declared
> myvalue text[][]
>
> insert into vladik (myval)
> values
> (
> '{{"\",A", "\"B"}, {"Y", "Q"}}'
> )
>
>
> What do you guys use in your treasurechest of 'addons'
> to successfully parse out the above trickery
> and get
>
> and get the 4 strings
> ",A
> "B
> Y
> Q
>
> from within Postgres stored procedure as well as C++ or other client
> code.
>
>
> It seems to me that it is not possible with any built-in command
> available
> to easily extract the strings out to a multidimensional array


Actually its pretty easy.

SELECT myval[i][j]
FROM vladik
CROSS JOIN generate_series(1, array_upper(myval, 1)) i
CROSS JOIN generate_series(1, array_upper(myval, 2)) j