Date: Fri, 13 Jun 2003 03:26:11 +0200
From: weigelt@metux.de
To: PGSQL-SQL <pgsql-sql@postgresql.org>
Subject: question on rules
Message-ID: <20030613012611.GA25276@metux.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.3.27i


hi folks,

i'd like to write an rule which fills out some empty attrs on 
insert (w/ data from other given attrs).

the table structure is:
CREATE TABLE foo (start date, duration integer, endtime date);

and the rule is:
CREATE RULE foo1 AS ON INSERT TO foo WHERE new.endtime = NULL DO 
    INSERT INTO foo SELECT new.start, new.duration, new.start + new.duration;
    
when i try to insert some data (INSERT INTO foo SELECT '2003-01-01', '12';)
i get the error: query rewritten 10 times, may contain cycles.

how can i avoid this loop ?

cu
-- 
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux ITS 
 Webhosting ab 5 EUR/Monat.          UUCP, rawIP und vieles mehr.

 phone:     +49 36207 519931         www:       http://www.metux.de/     
 fax:       +49 36207 519932         email:     contact@metux.de
 cellphone: +49 174 7066481	     smsgate:   sms.weigelt@metux.de
---------------------------------------------------------------------
 Diese Mail wurde mit UUCP versandt.      http://www.metux.de/uucp/