Postgres User wrote:
The problem turned out to be related to my function..
Given this table:
CREATE TABLE "table2" (
"s_val" numeric(6,2),
"e_val" numeric(6,2)
) WITH OIDS;
I am curious what would happen if you wrote your procedure like this:
declare
retval numeric(6,2);
rec table2%ROWTYPE;
begin
rec.s_val = 100;
rec.e_val = 101;
retval = (rec.s_val - rec.e_val) / rec.s_val;
return retval;
end
Also, one wonders why you need to do the calculation via a row or record at
all, when it would seem so easy just to plug in the values.
--
Lew
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
