On Wed, 26 Jan 2005 12:40:24 +0500, Sibtay Abbas <sibtay@xxxxxxxxx> wrote: > 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 > Something which i forgot to mention is that the output of the above mentioned procedure is NOTICE: NULL which means and x[3][1] was not initiliazed with the statement x[3][1] := '20'; ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
