Re: Declaring multidimensional arrays in pl/pgsql

On Nov 29, 2007 3:34 AM, Max Zorloff <zorloff@gmail.com> wrote:
> According to the docs it seems that only way would be to declare it as
> something like :
> myArray := ARRAY[[1,2], [3,4], [5,6]];

You can declare arbitrary-sized, n-dimensional arrays:
...
DECLARE
  myArray integer[][]; -- two-dimensional integer array
BEGIN
...
END;
...

See:
http://www.postgresql.org/docs/8.1/static/arrays.html