RE: simple rule question - Mailing list pgsql-general

From Andrew Snow
Subject RE: simple rule question
Date
Msg-id JEEGIJPOJIGGIIHGKOKOEEJLDDAA.andrew@modulus.org
Whole thread Raw
In response to simple rule question  (Neil Conway <nconway@klamath.dyndns.org>)
List pgsql-general
Try the CREATE RULE blah AS ON INSERT TO foo DO INSTEAD form of rule
creation (note the use of the keyword INSTEAD)..

> Would someone be kind enough to write a rule for me which does
> this? All the rules I've tried to write create infinite loops
> (since the RULE is defined as ON INSERT, and its action is
> doing an INSERT to the same table, which triggers the rule
> again).


- Andrew


pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: simple rule question
Next
From: Janning Vygen
Date:
Subject: newbie sql question: select every day another quote