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