From: Sibtay Abbas <sibtay@gmail.com>
To: pgsql-sql@postgresql.org
Subject: working with multidimensional arrays in plpgsql
Date: Wed, 26 Jan 2005 12:02:50 +0500
Message-ID: <bd6a3551050125230248d49296@mail.gmail.com> (raw)
hello everyone
i am having problem with multidimensional arrays in plpgsql following
is the source code of the function which i am trying to run
CREATE OR REPLACE FUNCTION test() RETURNS VOID AS $$
DECLARE
x INTEGER[10][10];
tmp VARCHAR(40);
BEGIN
x[3][1] := '20'; ------i have even tried x[3][1] = 20
tmp := x[3][1];
RAISE NOTICE '%', tmp;
RETURN;
END;
$$LANGUAGE 'plpgsql';
As you might have observed here, the actual problem is
how to do assignment to multidimensional array locations using the
subscript operater.
Thank you
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sibtay@gmail.com
Subject: Re: working with multidimensional arrays in plpgsql
In-Reply-To: <bd6a3551050125230248d49296@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox