From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | list(at)blueaxis(dot)com |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: numericOnly trigger |
Date: | 2007-09-21 17:31:27 |
Message-ID: | 46F3FFEF.70702@mail.nih.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Derrick Betts | 2007-09-21 23:39:30 | Re: numericOnly trigger |
Previous Message | Derrick Betts | 2007-09-21 16:03:24 | numericOnly trigger |