Re: [SQL] working with multidimensional arrays in plpgsql

2005-01-26 Thread Richard Huxton
Sibtay Abbas 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 DECLARE x INTEGER[10][10]; x[3][1] := '20'; --i have even tried x[3][1] = 20 As you might have observed here,

Re: [SQL] working with multidimensional arrays in plpgsql

2005-01-26 Thread Sibtay Abbas
thank you very much for your reply I did as you specified and it worked fine thankz :) On Wed, 26 Jan 2005 09:29:53 +, Richard Huxton dev@archonet.com wrote: Sibtay Abbas wrote: hello everyone i am having problem with multidimensional arrays in plpgsql following is the source code

Re: [SQL] working with multidimensional arrays in plpgsql

2005-01-26 Thread Josh Berkus
Sibtay, As you might have observed here, the actual problem is how to do assignment to multidimensional array locations using the subscript operater. Maybe post your results, too? -- Josh Berkus Aglio Database Solutions San Francisco ---(end of

[SQL] working with multidimensional arrays in plpgsql

2005-01-25 Thread Sibtay Abbas
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