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. >

[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