question on rules
От | weigelt@metux.de |
---|---|
Тема | question on rules |
Дата | |
Msg-id | 20030613012611.GA25276@metux.de обсуждение исходный текст |
Ответы |
Re: question on rules
Re: question on rules |
Список | pgsql-sql |
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.decellphone:+49 174 7066481 smsgate: sms.weigelt@metux.de ---------------------------------------------------------------------Diese Mail wurde mit UUCP versandt. http://www.metux.de/uucp/
В списке pgsql-sql по дате отправления: