Re: [SQL] Rules: passing new/old to functions

2003-06-26 Thread Tom Lane
Gunter Diehl <[EMAIL PROTECTED]> writes: > create funtion f1(v, v) returns void as '...' > create rule vupt as on update to v do instead select f1(new, old) > While accepting this definitions, pg says it can not handle "whole-tuple > references" at runtime. FWIW, the "old" case works fine. "new"

[SQL] Rules: passing new/old to functions

2003-06-26 Thread Gunter Diehl
How to pass the special variables new / old to functions? e.g. I'd like to to something like this (v is a view): create funtion f1(v, v) returns void as '...' create rule vupt as on update to v do instead select f1(new, old) While accepting this definitions, pg says it can not handle "whole-tupl