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

From Tom Lane
Subject Re: passing new/old record in pl/pgsql trigger functions to other functions
Date
Msg-id 13912.1085984096@sss.pgh.pa.us
Whole thread Raw
In response to passing new/old record in pl/pgsql trigger functions to other functions  (basic <basic@mozdev.org>)
List pgsql-sql
basic <basic@mozdev.org> writes:
>    In Postgresql version 7.4.1 How does one pass new/old record in a 
> pl/pgsql trigger function to other functions?

You can't ... NEW and OLD are of unspecified-record types, and there's
no support for passing such things to other functions.  You pretty much
have to do the tedious "myfunc(NEW.f1, NEW.f2, ...)".

I've done some work recently to improve the support for passing record
types around as full-fledged datatypes.  The above still doesn't quite
work, and I can't promise that it'll get done for 7.5, but hopefully by
the release after that it will.
        regards, tom lane


pgsql-sql by date:

Previous
From: basic
Date:
Subject: passing new/old record in pl/pgsql trigger functions to other functions
Next
From: sad
Date:
Subject: type regclass casting