Postgres Pro
Downloads
Home   >   mailing lists

passing new/old record in pl/pgsql trigger functions to other functions - Mailing list pgsql-sql

From basic
Subject passing new/old record in pl/pgsql trigger functions to other functions
Date
Msg-id 40BAC7E5.4020509@mozdev.org
Whole thread Raw
Responses Re: passing new/old record in pl/pgsql trigger functions to other functions
type regclass casting
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: About intervals
Next
From: Tom Lane
Date:
Subject: Re: passing new/old record in pl/pgsql trigger functions to other functions