basic <basic(at)mozdev(dot)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
In response to
pgsql-sql by date
|Next:||From: sad||Date: 2004-05-31 07:52:42|
|Subject: type regclass casting|
|Previous:||From: basic||Date: 2004-05-31 05:51:33|
|Subject: passing new/old record in pl/pgsql trigger functions to other functions|