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..