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" 
To: "Peter Eisentraut" 
Cc: "mazzo" ; 
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  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?
>