Re: [GENERAL] NEW variable values in trigger functions

2006-01-05 Thread Tom Lane
"Ken Winter" <[EMAIL PROTECTED]> writes: > 1. What is the value of the NEW variable for a column that is not mentioned > in an UPDATE statement? Is it NULL? If not NULL, what? No, it's whatever value is going to be assigned to the new row (which in this particular case would be the same as the O

[GENERAL] NEW variable values in trigger functions

2006-01-05 Thread Ken Winter
1. What is the value of the NEW variable for a column that is not mentioned in an UPDATE statement? Is it NULL? If not NULL, what? For example, given this table: my_tbl (id integer, att1 varchar, att2 varchar) and a row-wise ON UPDATE OR INSERT trigger function containing this condition