Re: Simple math statement - problem - Mailing list pgsql-general

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