From: basic <basic@mozdev.org>
To: pgsql-sql@postgresql.org
Subject: passing new/old record in pl/pgsql trigger functions to other functions
Date: Mon, 31 May 2004 13:51:33 +0800
Message-ID: <40BAC7E5.4020509@mozdev.org> (raw)
Hi,
In Postgresql version 7.4.1 How does one pass new/old record in a
pl/pgsql trigger function to other functions? I tried to pass it
directly but the select/perform statement caused an error saying "NEW
used in query that is not in a rule". I've tried 'rename' in the declare
block but that didn't work at all (I get 'invalid column', which I
assume it means rename did not work at all). Besides copying the record
columns one by one, is there any other way to do this?
--
basic
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: basic@mozdev.org
Subject: Re: passing new/old record in pl/pgsql trigger functions to other functions
In-Reply-To: <40BAC7E5.4020509@mozdev.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox