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...
 
Can anyone help me out please..??
Sorry if i post here but i looked on deja.com but i didn't find anything..
 
Thanks in advance..

Reply via email to