I am starting to work with rules. I think I have them down but the
folowing one is giving me grief. It tells me that it has rewritten 100
times and probably has looped. The columns ID and Location make up the
primary key so I am sure that the result update should only effect one
row. Anyone know what I am missing?
CREATE OR REPLACE RULE "set_changed" AS ON UPDATE TO "GameInformation"
WHERE NEW."Changed" =FALSE DO UPDATE "GameInformation" SET "Changed" = TRUE
WHERE "Location" = NEW."Location" AND "ID" = NEW."ID";
--- Adam Kavan
--- akavan(at)cox(dot)net