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

From Bruno Wolff III
Subject Re: abs() does not exists..
Date
Msg-id 20010613094546.A21307@wolff.to
Whole thread Raw
In response to Re: abs() does not exists..  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
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
isnegative, 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?

pgsql-general by date:

Previous
From: Travis Bauer
Date:
Subject: 7.1.2 temporary file area
Next
From: Martín Marqués
Date:
Subject: Re: [SQL] ORDER BY what?