"Karl O. Pinc" <kop@xxxxxxxx> 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
