Content-Type: text/plain;
  charset="iso-8859-1"
From: Richard Huxton <dev@archonet.com>
Organization: Archonet Ltd
To: Terence Kearns <terencek@isd.canberra.edu.au>,
	pgsql-sql@postgresql.org
Subject: Re: (trigger function) -> ERROR: NEW used in non-rule query
Date: Fri, 18 Jul 2003 10:03:42 +0100
User-Agent: KMail/1.4.3
References: <3F17AE38.5020302@cts.canberra.edu.au>
In-Reply-To: <3F17AE38.5020302@cts.canberra.edu.au>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200307181003.42279.dev@archonet.com>

On Friday 18 Jul 2003 9:22 am, Terence Kearns wrote:
> I'm writing a trigger which wants to reference the pre-defined NEW record.
>
> I can do this
> idval :=3D NEW.blah;
>
> This works fine!!!
>
> What I really need to do is
> idval :=3D NEW.(quote_ident(TG_ARGV[3]));
> or this
> idval :=3D NEW.(TG_ARGV[3]);

I'll give you the short answer - no you can't do this (in plpgsql). Which=
=20
isn't to say it'll never be possible, but not at the moment.

Can you afford to look at an alternative language? I'd suggest looking at T=
CL,=20
although I must admit I've never used it myself.


--=20
  Richard Huxton