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(at)wolff(dot)to>
To: "Peter Eisentraut" <peter_e(at)gmx(dot)net>
Cc: "mazzo" <jambo(at)aruba(dot)it>; <pgsql-general(at)postgresql(dot)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(at)gmx(dot)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?
>