Re: abs() does not exists..

How about a trigger/function that does this:

if val < 0 then val = val * -1

--rob

----- Original Message -----
From: "Bruno Wolff III" <bruno@wolff.to>
To: "Peter Eisentraut" <peter_e@gmx.net>
Cc: "mazzo" <jambo@aruba.it>; <pgsql-general@postgresql.org>
Sent: Wednesday, June 13, 2001 10:45 AM
Subject: Re: abs() does not exists..


> On Wed, Jun 13, 2001 at 12:11:42AM +0200,
>   Peter Eisentraut <peter_e@gmx.net> wrote:
> > mazzo writes:
> >
> > > 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...
>
> Couldn't you do this using a rule to update the table and a constraint on
> the table to prevent bad data from getting into the table without using
the
> rule?
>