passing new/old record in pl/pgsql trigger functions to other functions

From: basic <basic(at)mozdev(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: passing new/old record in pl/pgsql trigger functions to other functions
Date: 2004-05-31 05:51:33
Message-ID: 40BAC7E5.4020509@mozdev.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-05-31 06:14:56 Re: passing new/old record in pl/pgsql trigger functions to other functions
Previous Message CoL 2004-05-30 22:13:08 Re: multi results with functions