Re: The relative stability of different procedural languages

From: "BigSmoke" <bigsmoke(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: The relative stability of different procedural languages
Date: 2006-12-08 12:35:56
Message-ID: 1165581356.130316.297900@f1g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Dec 7, 11:42 pm, tony_cad(dot)(dot)(dot)(at)amsoftwaredesign(dot)com (Tony Caduto)
wrote:
> BigSmoke wrote:
> > On Dec 7, 11:07 pm, mmonc(dot)(dot)(dot)(at)gmail(dot)com ("Merlin Moncure") wrote:
>
> >> On 7 Dec 2006 14:02:53 -0800, BigSmoke <bigsm(dot)(dot)(dot)(at)gmail(dot)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?

Yes, you're missing something. ;-) Your example doesn't work in my case
where mycolumnname is in argument that is passed to the function.

- Rowan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Harald Fuchs 2006-12-08 12:42:33 Re: How to use outer join in update
Previous Message Devrim GUNDUZ 2006-12-08 12:28:34 Re: Questions about postgresql-8.2.0-2PGDG.src.rpm