Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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: Thu, 29 Nov 2007 12:34:03 +0400
  • Message-id: <op(dot)t2joq1hill0p5y(at)1-rtt202dnf3uds(dot)mshome(dot)net>

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.



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group