Peter Krauss <ppkra...@gmail.com> writes: > I need to access an array-item from an array of arrays.
Multi-dimensional arrays in Postgres are not "arrays of arrays". If you persist in thinking they are, it's mostly going to lead you astray about what will work or not. Having said that, you might find that plpgsql's FOREACH ... SLICE ... IN ARRAY ... LOOP construct would help you, if you need to iterate through the rows sequentially. http://www.postgresql.org/docs/9.4/static/plpgsql-control-structures.html#PLPGSQL-FOREACH-ARRAY regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
