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().
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 trigge
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 s