"Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> writes:
> I have a check constraint that runs a PlPgsql function which returns a
> pass/ fail status which the constraint uses to allow or disallow the
> value. This is not a trigger function. It's just a plain-ole
> PlPgsql. Is there a way I can read (not write, just read) the
> NEW.column values that a trigger function would normally have access
Sure. Just pass them into your validator func as parameters.
But why are you avoiding use of a trigger here?
> Thanks in Advance for any help.
Postgres DBA/Development Consulting
In response to
pgsql-general by date
|Next:||From: Gauthier, Dave||Date: 2011-03-31 20:22:56|
|Subject: Re: Access to NEW.column outside of a trigger function.|
|Previous:||From: Davi Duarte||Date: 2011-03-31 19:58:00|
|Subject: Pl/Python error when import "from __future__"|