one more word about rules

First, thank youu for the accurate and exhausting answer.

And a new idea...  I've encountered a problem and I think rules would be
the nicest and the best solutions for it.  After SELECTing rows I need to
update some statistic fields such as timestamp of last reference and
number of all references up to now, etc.

In pgsql 7.0.2, there is no way to create a rule which can perform  an
additional query after SELECT. What I'm writing  about:

CREATE RULE r_my_dream AS ON SELECT TO xxx
DO UPDATE xxx SET c_lastref = current_timestamp, c_refnum = c_refnum + 1
WHERE xxx.oid = old.oid;

I know that this could be solved with FOR UPDATE clause and then with an
UPDATE query.
But, it would be so nice if it was totally transparent. (_only_one_ query)
Can my dream be realised?

Papp Gyozo

s7461pap@hszk.bme.hu, gerzson17@freemail.hu