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

2005-12-03 Thread Karl O. Pinc
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

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

2005-12-03 Thread Tom Lane
Karl O. Pinc [EMAIL PROTECTED] 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

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

2005-12-03 Thread Karl O. Pinc
On 12/03/2005 10:29:43 PM, Tom Lane wrote: Karl O. Pinc [EMAIL PROTECTED] writes: 2nd, nowhere have I found a NEW.* syntax (as written). 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

[GENERAL] New.* and old.* as function arguments within rules

2005-12-02 Thread Karl O. Pinc
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 this syntax continuing to work? (It's tough searching on these strings. :-) TIA Karl

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

2005-12-02 Thread Andreas Kretschmer
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