Problem solved. Hacking away 'til the wee hours yielded a solution
using an ON UPDATE rule, adding a row to a new table. Successful test
sample follows, for anyone interested.
Scott
CREATE TABLE colors (
clrs_pkey SERIALPRIMARY KEY,
first_nametext UNIQUE DEFAULT NULL,
fav_col
My original post got eaten. Apologies in advance if you receive this
message twice.
I am trying to construct a rule that performs an UPDATE if specific
conditions are met in an INSERT statement. Limiting UPDATE's SET
action to just the new row by testing for the new primary key is
failing fo
