Re: [GENERAL] multiple action rules

2005-06-23 Thread Tom Lane
Scott Marlowe <[EMAIL PROTECTED]> writes: > Now I'm thinking I should make a patch for a demonstration of making a > rule with >1 action though... You're right, there are no such examples. It would be interesting to make a full-fledged demonstration of maintaining a join view (where delete from t

Re: [GENERAL] multiple action rules

2005-06-23 Thread Scott Marlowe
On Wed, 2005-06-22 at 20:28, Tom Lane wrote: > Scott Marlowe <[EMAIL PROTECTED]> writes: > > Well, what really gets me is that basically, the syntax diagram in > > the psql environment has a syntax diagram that makes sense to me. > > > So I guess if there was a "patch" it would basically referenc

Re: [GENERAL] multiple action rules

2005-06-22 Thread Tom Lane
Scott Marlowe <[EMAIL PROTECTED]> writes: > Well, what really gets me is that basically, the syntax diagram in > the psql environment has a syntax diagram that makes sense to me. > So I guess if there was a "patch" it would basically reference the syntax > rules given by psql \h create rule in th

Re: [GENERAL] multiple action rules

2005-06-22 Thread Scott Marlowe
On Wed, 2005-06-22 at 19:49, Tom Lane wrote: > Scott Marlowe <[EMAIL PROTECTED]> writes: > >> So, what's the magic pixie dust I need to sprinkle on this to make it > >> work? > > > Never mind, I finally figured it out... About three minutes after > > posting this. sheesh. > > If you think the d

Re: [GENERAL] multiple action rules

2005-06-22 Thread Tom Lane
Scott Marlowe <[EMAIL PROTECTED]> writes: >> So, what's the magic pixie dust I need to sprinkle on this to make it >> work? > Never mind, I finally figured it out... About three minutes after > posting this. sheesh. If you think the docs are insufficiently clear, feel free to send in a document

Re: [GENERAL] multiple action rules

2005-06-22 Thread Scott Marlowe
On Wed, 2005-06-22 at 18:31, Scott Marlowe wrote: > OK, so I'm trying to make a rule with >1 action. > > The docs, not so helpfully, only seem to show a single action rule (at > least in the rules section, not sure about elsewhere) The syntax > diagram: > > CREATE RULE rule_name AS ON event >