On 12/03/2005 01:43:38 AM, Andreas Kretschmer wrote:
Karl O. Pinc <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
