BigSmoke wrote:
> On Dec 7, 11:07 pm, mmonc...@gmail.com ("Merlin Moncure") wrote:
>
>> On 7 Dec 2006 14:02:53 -0800, BigSmoke <bigsm...@gmail.com> wrote:
>>
>>
>>> I'm facing a particular task for which I need any procedural language
>>> but PL/PgSQL. I can't use PL/PgSQL because it doesn't allow me to use
>>> local variables such as new and old from a dynamic command.
>>>
>
>
>> could you clarify what you are trying to do and why pl/pgsql cant do it?
>>
>
> I'm dealing with a trigger function which needs to check the nullness
> of a column in 'new' and 'old'. The catch is that the trigger function
> needs to take the name of that column as an argument. (I've tried a
> kludge which stores 'new' and 'old' in a temporary table, but this
> kludge seems too unreliable to trust.)
>
>
Why can't you just use something like this:
IF new.yourcolumnname IS NULL THEN
END IF;
I test for null in PLpgsql all the time.
Am I missing something?
Later,
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration