Re: New.* and old.* as function arguments within rules

"Karl O. Pinc" <kop(at)meme(dot)com> writes:
> 2nd, nowhere have I found a NEW.* syntax (as written).

This could certainly stand to be better documented, but there is an
example for instance here:
http://developer.postgresql.org/docs/postgres/xfunc-sql.html#AEN31568

In general, "foo.*" where foo is a visible table alias is meaningful
anywhere that a rowtype value would be accepted. There is a special
case at the top level of a SELECT result list, where it will be broken
apart into a list of foo's component fields because the SQL spec says
so.

At one time you could just write "foo" instead of "foo.*", but that's
deprecated because it's ambiguous against the case of a simple column
"foo". I'm not sure to what extent it still works at all, and it
probably will stop working in any remaining cases someday.

NEW/OLD are not different from other table aliases as far as these
matters go.

regards, tom lane