Message-ID: <3EE96864.1000504@bt.jordan.pl>
Date: Fri, 13 Jun 2003 08:00:04 +0200
From: Tomasz Myrta <jasiek@bt.jordan.pl>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; en-US;
 rv:1.3) Gecko/20030312
MIME-Version: 1.0
To: weigelt@metux.de
Cc: PGSQL-SQL <pgsql-sql@postgresql.org>
Subject: Re: question on rules
References: <20030613012611.GA25276@metux.de>
In-Reply-To: <20030613012611.GA25276@metux.de>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Dnia 2003-06-13 03:26, Uz.ytkownik weigelt@metux.de napisa?:
> 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 ?
For this case creating trigger would be much better than rule.
I think, you can't use rules this way.

Regards,
Tomasz Myrta