From: | J Greenbaum <jj(at)bu(dot)edu> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | assigning values to array elements |
Date: | 2003-01-13 20:25:47 |
Message-ID: | Pine.A41.4.10.10301131523550.206436-100000@acsrs1.bu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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: plpgsql: ERROR during
compile of norm_n_scan near line 27 ERROR: parse error at or near "["
As you can see, I'm trying to assign a value to an array element, but it
isn't working for some reason. FYI, "norm" is declared as a floating
point array of unlimited size. Please let me know if you have any
suggestions. Thanks!!
-Jay Greenbaum
P.S. My apologies for posting this to 2 lists!
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-01-13 21:04:16 | Re: assigning values to array elements |
Previous Message | Chris Travers | 2003-01-13 20:18:23 | Re: PgSQL 7.3: /opt/pgsql/bin/postgres: Execute permission denied. |