Re: [GENERAL] abs() does not exists..

2001-06-12 Thread Stephan Szabo
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

[GENERAL] abs() does not exists..

2001-06-12 Thread mazzo
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