[GENERAL] Rules question

[Adam Kavan]

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
--- [EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings