On Sat, Aug 15, 2009 at 01:41:12PM -0400, V S P wrote:
> but running into a problem as I cannot typecast correctly
>
> select V[i][j]
> FROM
> (select '{{A,B,C},{D,E,F}}') as V
> CROSS JOIN generate_series(1, 3) i
> CROSS JOIN generate_series(1,2) j
>
> Does not work, because V is not an array (it is a string)
> and I do not know where to put the typecast
> ::text[][]
Not sure what you tried, but the following does the "right" thing for
me:
SELECT ('{{A,B,C},{D,E,F}}'::text[])[1][1];
The brackets are needed so that PG doesn't get confused between the type
declaration and the array indexing.
--
Sam http://samason.me.uk/