Re: Declaring multidimensional arrays in pl/pgsql - Mailing list pgsql-general

From Rodrigo De León
Subject Re: Declaring multidimensional arrays in pl/pgsql
Date
Msg-id a55915760711290611l6296d4dcic05fe54ac95b7e41@mail.gmail.com
Whole thread Raw
In response to Declaring multidimensional arrays in pl/pgsql  ("Max Zorloff" <zorloff@gmail.com>)
Responses Re: Declaring multidimensional arrays in pl/pgsql  ("Rodrigo De León" <rdeleonp@gmail.com>)
Re: Declaring multidimensional arrays in pl/pgsql  ("Max Zorloff" <zorloff@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: 1 cluster on several servers
Next
From: Glyn Astill
Date:
Subject: Slony-I creation scripts not available