Hi,
I try to save hierarchical Data with an
id that contains strings which represent
the way through the tree. On each depth level
I can have a maxcount number of elements.
If I want move subtrees, I have to change these
id-fields. I want implement this as a RULE in the
Database, that the using application not have to
call any SQL statements in a sequence.
I tried:
CREATE RULE hangup AS
ON UPDATE TO "products"
WHERE OLD."id" != NEW."id"
DO INSTEAD
UPDATE "products" SET "id"=NEW."id" ||
substring("id",char_length(OLD."id")+1) WHERE "id" LIKE (OLD."id" || '~')
That runs definitely in recursion, and I have no idea to prevent
this. Perhaps it runs with triggers and/or Functions.
Thank for your help
Falk
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
