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

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

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

Re: [SQL] array_lower /array_prepend doubt

Tom Lane wrote: > Joe Conway <[EMAIL PROTECTED]> writes: > > We may need another extension to the array literal syntax in > > order to deal with this. I'll report back after I've had some time to > > study it. > > There already is support in array_in for specification of the array > dimensions (