Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WS4LS-0001uu-Pv for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Mar 2014 12:51:15 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WS4LR-0001n6-UJ for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Mar 2014 12:51:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WS4LQ-0001mx-0z for pgsql-hackers@postgresql.org; Mon, 24 Mar 2014 12:51:12 +0000 Received: from mail-pa0-x22b.google.com ([2607:f8b0:400e:c03::22b]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WS4LN-0003sw-9l for pgsql-hackers@postgresql.org; Mon, 24 Mar 2014 12:51:11 +0000 Received: by mail-pa0-f43.google.com with SMTP id bj1so5433024pad.30 for ; Mon, 24 Mar 2014 05:51:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=Zgy9zXaObDVDpbYMvpdluqFsMTMF2pvoGXMdtVayi70=; b=BQeG0ZLXTGuXNcErWlV1Fiw1f/nAUp1MhTLAES6dyKsHrPvr5OU5+McnDT/2+SLjKw sWtb/UB2vcF/wneKuBpbf2XiJIWDGM3wqq3aOpQ/lnqcdMTcLADhYoi4jvShiH374fjw CE1bHRicvJeUITDXjohM15PY7DHgUYBcqYFSuhFGNoAw2zpbm/45Qju9CgiGQgkvOTh6 qHzBP7vyLZzoCeFqCnQt9gv4l2xranFF4UFPhCpIgFXiAQVxW+XG7oTtu0/rj4QmWw0b wKnFpPdRxvbXlKSkj0dBe+XkENuBU/9EWCGk+FtoowVPm0RHgMyK76EU07s2P5TUkZ3G BFeA== MIME-Version: 1.0 X-Received: by 10.67.2.34 with SMTP id bl2mr71174081pad.58.1395665467511; Mon, 24 Mar 2014 05:51:07 -0700 (PDT) Received: by 10.70.53.8 with HTTP; Mon, 24 Mar 2014 05:51:07 -0700 (PDT) In-Reply-To: <532C6111.4040102@2ndquadrant.com> References: <532B4E72.90309@2ndquadrant.com> <532C6111.4040102@2ndquadrant.com> Date: Mon, 24 Mar 2014 21:51:07 +0900 Message-ID: Subject: Re: Patch for CREATE RULE sgml -- Was in: [DOCS] From: Fujii Masao To: Emanuel Calvo Cc: "pgsql-hackers@postgresql.org" Content-Type: multipart/mixed; boundary=047d7b15a49d6aaae004f559b08c X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org --047d7b15a49d6aaae004f559b08c Content-Type: text/plain; charset=ISO-8859-1 On Sat, Mar 22, 2014 at 12:56 AM, Emanuel Calvo wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA512 > > > > Hi guys, > > I realized that the output of the CREATE RULE has not a detailed > output for the "events" parameter. > > But the question here is that I'm not sure which format follow: > > { INSERT | UPDATE | DELETE | SELECT} > > or > > INSERT > UPDATE > DELETE > SELECT > - -- > > > I attach a patch for each one. Though I'm not sure the right policy of the format in synopsis, ISTM that the following format is suitable in this case, i.e., if the value list is very simple. Patch attached. SELECT | INSERT | UPDATE | DELETE Regards, -- Fujii Masao --047d7b15a49d6aaae004f559b08c Content-Type: text/x-patch; charset=US-ASCII; name="add_events_on_create_rule_fujii.patch" Content-Disposition: attachment; filename="add_events_on_create_rule_fujii.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_ht5r01fl2 KioqIGEvZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVfcnVsZS5zZ21sCi0tLSBi L2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3J1bGUuc2dtbAoqKioqKioqKioq KioqKioKKioqIDI0LDI5ICoqKiogUG9zdGdyZVNRTCBkb2N1bWVudGF0aW9u Ci0tLSAyNCwzMyAtLS0tCiAgQ1JFQVRFIFsgT1IgUkVQTEFDRSBdIFJVTEUg PHJlcGxhY2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPm5hbWU8L3JlcGxhY2Vh YmxlPiBBUyBPTiA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+ZXZl bnQ8L3JlcGxhY2VhYmxlPgogICAgICBUTyA8cmVwbGFjZWFibGUgY2xhc3M9 InBhcmFtZXRlciI+dGFibGVfbmFtZTwvcmVwbGFjZWFibGU+IFsgV0hFUkUg PHJlcGxhY2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPmNvbmRpdGlvbjwvcmVw bGFjZWFibGU+IF0KICAgICAgRE8gWyBBTFNPIHwgSU5TVEVBRCBdIHsgTk9U SElORyB8IDxyZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1ldGVyIj5jb21tYW5k PC9yZXBsYWNlYWJsZT4gfCAoIDxyZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1l dGVyIj5jb21tYW5kPC9yZXBsYWNlYWJsZT4gOyA8cmVwbGFjZWFibGUgY2xh c3M9InBhcmFtZXRlciI+Y29tbWFuZDwvcmVwbGFjZWFibGU+IC4uLiApIH0K KyAKKyA8cGhyYXNlPndoZXJlIDxyZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1l dGVyIj5ldmVudDwvcmVwbGFjZWFibGU+IGNhbiBiZSBvbmUgb2Y6PC9waHJh c2U+CisgCisgICAgIFNFTEVDVCB8IElOU0VSVCB8IFVQREFURSB8IERFTEVU RQogIDwvc3lub3BzaXM+CiAgIDwvcmVmc3lub3BzaXNkaXY+CiAgCg== --047d7b15a49d6aaae004f559b08c Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers --047d7b15a49d6aaae004f559b08c--