Re: [SQL] Issue with plpgsql trigger

2004-07-29 Thread Oeln
Only wanted to indicate further that I know that IF loop is bad logic in itself, where oper will get overwritten in each case. I've now got the following instead: CREATE FUNCTION online_pct_trig() RETURNS opaque AS ' DECLARE i1hrtimestamp; i1day timestamp; i1wkt

[SQL] Issue with plpgsql trigger

2004-07-29 Thread Oeln
I'm only learning this, but I've got a working function that I want to be invoked in a trigger. The function itself is: CREATE FUNCTION online_pct_func(integer, interval) RETURNS boolean AS ' DECLARE on numeric; off numeric; o_pct numeric; op varchar; BEGIN