Trigger functions take no arguments (their arguments
are passed in differently) and return opaque.
That's why it's looking for abs() rather than
abs(<type>).
Write a plpgsql trigger function that makes the
change to the value.
On Tue, 12 Jun 2001, mazzo wrote:
> 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..
>