Postgres Pro
Downloads
Home   >   mailing lists

abs() does not exists.. - Mailing list pgsql-general

From mazzo
Subject abs() does not exists..
Date
Msg-id 001901c0f37d$30bb0b80$0200a8c0@pcsilvia
Whole thread Raw
Responses Re: abs() does not exists..  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: abs() does not exists..  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Tree view
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..

pgsql-general by date:

Previous
From: "Tim Barnard"
Date:
Subject: Re: libpq++ PgDatabase and PgConnection
Next
From: "Andrew W. Schmeder"
Date:
Subject: Re: pg_dump problem... continued