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
DECLARE x INTEGER[10][10];
x[3][1] := '20'; ------i have even tried x[3][1] = 20
As you might have observed here, the actual problem is how to do assignment to multidimensional array locations using the subscript operater.
Actually, the problem is that the array "x" has been initialised to NULL. Therefore, you can't set individual values. Try a line like:
x := '{}';
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match