Re: [GENERAL] new.id has wrong value in INSERT RULE

"Ian McFarland" <[EMAIL PROTECTED]> writes: > CREATE RULE table_b_insert_rule AS ON INSERT TO table_b > DO (UPDATE table_b SET active = 'f', yield = new.id WHERE table_a_id > = new.table_a_id AND id != new.id;); Rules are macros. Since what is substituted for new.id in this case is a nextv

[GENERAL] new.id has wrong value in INSERT RULE

Hi, To explain the problem as clearly as I can I've included the schema, rule, inserts, output and explanation below. CREATE TABLE table_a ( id serial PRIMARY KEY, nametext, active