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