Skip site navigation (1) Skip section navigation (2)

Re: numericOnly trigger

From: Derrick Betts <list(at)blueaxis(dot)com>
To: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: numericOnly trigger
Date: 2007-09-21 23:39:30
Message-ID: 46F45632.3080906@blueaxis.com (view raw or flat)
Thread:
Lists: pgsql-novice
Sean Davis wrote:
> Derrick Betts wrote:
>> I was wondering if anyone has built a trigger or etc. that verifies the
>> validity of an entry that is being posted to the database. I would like
>> to do the following:
>>    1.    Iterate through the column types in the table being updated
>>    2.    If the column type is numeric or real, or etc.,
>>        a. remove all the strings from the New.value
>>        b. set the New.value to the newly stripped value
>>     3.    Update the table with the modified values.
>>
>> The part I was hoping not to have to reproduce, if anyone has it and is
>> willing to share it, is the logic for iterating through the column types
>> and cleaning the specific values for update.
> 
> I might be wrong, but I do not think your trigger will not actually fire
> if you try to do an update with text data in a column with a numeric
> datatype.  The type checking happens BEFORE a trigger fires, so you will
> simply get an error.
> 
> Sean
> 
> 
> 
If the trigger is a BEFORE UPDATE trigger will that not work?


In response to

Responses

pgsql-novice by date

Next:From: Derrick BettsDate: 2007-09-22 14:28:00
Subject: Re: numericOnly trigger
Previous:From: Sean DavisDate: 2007-09-21 17:31:27
Subject: Re: numericOnly trigger

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group