I am trying to create a rule that will set the 'date_created' field of a
newly inserted record to 'now'. When I try to write something like the
example in the book...
create rule example_5 as on insert to EMP where new.salary > 5000 do update newset salary = 5000
as
create rule test_rule as on insert to candidate do update newset date_created = current_date;
that gives me an error of:
ERROR: parser: parse error at or near "date_created"
if I change it to this:
create rule test_rule as on insert to candidate do update candidate set date_created=current_date;
it creates the rule but when I do an insert it looks like it is updating
all the records except the one I'm inserting. So what's the best way to do
this. I have about 6 tables I would like to do this for. Thanks...