> select count(*) from new ??? - new refers to a record not a table name
In the description in the manual, new and old are described as
relations... Also, isn't the point that the query is rewritten into the
new query with rules, thus if you update more than one row, new should
be all the updated rows, not just one at a time (a rule is not a
trigger)?
>
> Try
>
> create rule user_insert_count as
> on update to "user"
> do also
> insert into users (time,users) values (
> new.created, (select count(*) from "user" where destroyed is null));
I tried that, but "user" only contains the old (non-updated) records,
so the record count will be off by one in either direction...
Regards,
Egil