Declaring multidimensional arrays in pl/pgsql

From: "Max Zorloff" <zorloff(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Declaring multidimensional arrays in pl/pgsql
Date: 2007-11-29 08:34:03
Message-ID: op.t2joq1hill0p5y@1-rtt202dnf3uds.mshome.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, all.

I was wondering, can I really declare a 2-dimensional array of arbitrary
size in pl/pgsql?
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]];

But what if I pass the dimensions as function parameters?

My postgresql version is 8.1.

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pedro Doria Meunier 2007-11-29 08:51:53 test message
Previous Message Shane Ambler 2007-11-29 08:23:15 Re: 60 Seconds to connected to Postgresql using ODBC or PGAdmin