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 broadcast)

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 wrote: > Sibtay Abbas wrote: > > hello everyone > > > > i am having problem with multidimensional arrays in plpgsql following > > is the source code of the fu

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, t

[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