mazzo writes:
> Hi all..i'm trying to create a trigger that fires before i insert a value into a column and if the value i insert is
negative,it will change it to positive...
> I was trying with:
>
> create trigger postv before insert on my_table for each row execute procedure abs (column);
>
> But this doesn't seem to work and gives me the error i wrote in the subject...
Trigger procedures and regular functions cannot be mixed. You need to
write a special procedure that takes the old value and alters it to your
liking. See programmer's guide how to write trigger functions. PL/pgSQL
is probably best.
> Sorry if i post here but i looked on deja.com but i didn't find anything..
There are mailing list archives on the postgresql.org site and at
geocrawler.com.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
