7 moi

CREATE RULE "_update_path_article" AS	ON UPDATE TO _article	WHERE (OLD.parent_id != NEW.parent_id)	DO ALSO	(		UPDATE   _article		  SET    path = 		    (				 SELECT (_element.path || '.' || OLD.id)::ltree				 FROM  _element				 WHERE _element.id = NEW.parent_id			)		  WHERE  _article.id = OLD.id		;  		UPDATE   _element		  SET    _element.path =			(				NEW.path				||				subpath (_element.path, nlevel(OLD.path))			)		  WHERE  _element.path <@ OLD.path		  AND    nlevel(_element.path) > nlevel(OLD.path)	);