Re: [GENERAL] Dereferencing a 2-dimensional array in plpgsql

2005-01-31 Thread Tom Lane
Sven Willenberger <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I think we changed this in 8.0. Before 8.0, trying to assign to an >> element of a NULL array yielded a NULL result array, but I think now >> we let you produce a one-element array that way. >> > Using a 8.0 testbox I find that th

Re: [GENERAL] Dereferencing a 2-dimensional array in plpgsql

2005-01-31 Thread Sven Willenberger
Tom Lane wrote: Sven Willenberger <[EMAIL PROTECTED]> writes: The problem stems from being unable to assign values to an array without first initializing the array in plpgsql. I think we changed this in 8.0. Before 8.0, trying to assign to an element of a NULL array yielded a NULL result array,

Re: [GENERAL] Dereferencing a 2-dimensional array in plpgsql

2005-01-31 Thread Tom Lane
Sven Willenberger <[EMAIL PROTECTED]> writes: > The problem stems from being unable to assign values to an array without > first initializing the array in plpgsql. I think we changed this in 8.0. Before 8.0, trying to assign to an element of a NULL array yielded a NULL result array, but I think

Re: [GENERAL] Dereferencing a 2-dimensional array in plpgsql

2005-01-31 Thread Sven Willenberger
Tom Lane wrote: Sven Willenberger <[EMAIL PROTECTED]> writes: I am having an issue with trying to dereference a 2-dimensional array in plpgsql. The idea is to have an setup like: DECLARE myarray varchar[][]; myvar char; BEGIN --stuff myarray[1] := ''{value1,value2,value3}''; myarray[2] := ''{v

Re: [GENERAL] Dereferencing a 2-dimensional array in plpgsql

2005-01-31 Thread Tom Lane
Sven Willenberger <[EMAIL PROTECTED]> writes: > I am having an issue with trying to dereference a 2-dimensional array in > plpgsql. The idea is to have an setup like: > DECLARE > myarray varchar[][]; > myvar char; > BEGIN > --stuff > myarray[1] := ''{value1,value2,value3}''; > myarray[2] := ''{va