Re: [SQL] passing new/old record in pl/pgsql trigger functions to other functions

2004-05-30 Thread Tom Lane
basic <[EMAIL PROTECTED]> 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 h

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

2004-05-30 Thread basic
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