On 12/03/2005 01:43:38 AM, Andreas Kretschmer wrote:
Karl O. Pinc <kop@xxxxxxxx> schrieb: > Hi, > > I'm trying to make sure I understand what I'm doing. > > Where is new.* and old.* documented, as regards > using them as arguments to functions called from > rules? If it's not documented then can I rely
on the behavior?
http://www.postgresql.org/docs/8.1/interactive/triggers.html
Thanks for the reply but I've obviously got some big misunderstanding here. 1st, the docs above refer to triggers, not rules. AFIK rules are a completely different animal. 2nd, nowhere have I found a NEW.* syntax (as written). NEW (or OLD) seems to be a complete rowtype (or maybe recordtype), as far as triggers go anyway, and there's no explaination of what .* might mean in the context of a rowtype. Finally, the syntax seems to have something to do with calling functions. See: http://archives.postgresql.org/pgsql-general/2005-08/msg00653.php Which is what I found searching the archives trying to figure out the best way to pass data in NEW and OLD to functions called from within rules. Karl <kop@xxxxxxxx> Free Software: "You don't pay back, you pay forward." -- Robert A. Heinlein
