Re: [SQL] assigning values to array elements

2003-01-13 Thread Bruce Momjian
Tom Lane wrote: > J Greenbaum <[EMAIL PROTECTED]> writes: > > As you can see, I'm trying to assign a value to an array element, but it > > isn't working for some reason. > > plpgsql doesn't support that yet :-(. > > This needs to be fixed. I'm not sure why it doesn't have an entry in > TODO. Br

Re: [SQL] assigning values to array elements

2003-01-13 Thread J Greenbaum
Darn...guess I gotta do it in perl then. Thx for your help. On Mon, 13 Jan 2003, Tom Lane wrote: > J Greenbaum <[EMAIL PROTECTED]> writes: > > As you can see, I'm trying to assign a value to an array element, but it > > isn't working for some reason. > > plpgsql doesn't support that yet :-(. >

Re: [SQL] assigning values to array elements

2003-01-13 Thread Tom Lane
J Greenbaum <[EMAIL PROTECTED]> writes: > As you can see, I'm trying to assign a value to an array element, but it > isn't working for some reason. plpgsql doesn't support that yet :-(. This needs to be fixed. I'm not sure why it doesn't have an entry in TODO. Bruce, would you add something lik

[SQL] assigning values to array elements

2003-01-13 Thread J Greenbaum
Hello, I'm fairly new to postgres and I'm trying to write a PL/pgsql function and keep getting an error message. Here is the line that is giving me trouble: norm[i] := (NEW.area[i]/(A_slope * (i+18) + A_int)+NEW.area[i]/(C_slope * (i+18) + C_int))/2; The error message that I receive is: WARNING