Re: [GENERAL] NEW variable values in actions in rules

2006-02-01 Thread Tom Lane
"Ken Winter" <[EMAIL PROTECTED]> writes: > I have a table "person_h" with a not-null column "effective_date_and_time" > that defaults to CURRENT_TIMESTAMP. > I have a view "person" with the following rule defined on it: > CREATE RULE on_insert AS > ON INSERT TO person > DO INSTEAD (

Re: [GENERAL] NEW variable values in actions in rules

2006-02-01 Thread Ken Winter
Tom ~ Your answers (below) to my questions about the values of NEW columns in trigger functions was very clarifying for me (as well as being correct!). Now I'm having similar problems with NEW values in actions that are embedded in rules, and the answers don't seem to be the same. I have a table