"john huttley" <[EMAIL PROTECTED]> writes:
>> We've had parameterized triggers for years. Maybe you attach some
>> meaning to that term beyond what I do?
> I'm referring to the manual that says functions used for triggers must
> have no parameters and return a type Opaque.
The function has to be declared that way, but you can actually pass a
set of string parameters to it from the CREATE TRIGGER command. The
strings show up in some special variable or other inside the function.
(No, I don't know why it was done in that ugly way...) See the manual's
discussion of trigger programming.
regards, tom lane
- Re: [HACKERS] beta testing ver... Tom Lane
- Re: [HACKERS] beta testing ver... The Hermit Hacker
- Re: [HACKERS] beta testing ver... Thomas Lockhart
- Re: [HACKERS] beta testing ver... The Hermit Hacker
- Re: [HACKERS] Please advise features in 7.1... Ross J. Reedstrom
- Re: [HACKERS] Please advise features in 7.1... xuyifeng
- Re: [HACKERS] Please advise features in... Thomas Lockhart
- Re: [HACKERS] Please advise featur... Andrew Snow
- Re: [HACKERS] Please advise featur... Don Baccus
- Re: [HACKERS] Please advise features in 7.1 john huttley
- Re: [HACKERS] Please advise features in 7.1 Philip Warner
- Re: [HACKERS] Please advise features in 7.1 Don Baccus
