salah jubeh <s_ju...@yahoo.com> writes:
> Is this a bug ?
No, it's a documented, operating-as-designed behavior. Rules are macros
and therefore have all the usual multiple-evaluation-of-arguments
hazards.
If you just want to propagate data from one table to another, a trigger
is often a better choice, or at least one with fewer surprises.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
