Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-hackers-owner+M220941=pgsql-hackers-arkari@postgresql.org>)
	id 1Txf6t-0003vP-62 for pgsql-hackers@arkaria.postgresql.org;
	Tue, 22 Jan 2013 14:45:59 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-hackers-owner+M220941=pgsql-hackers-arkari@postgresql.org>)
	id 1Txf6s-0007Pj-6e for pgsql-hackers@arkaria.postgresql.org;
	Tue, 22 Jan 2013 14:45:58 +0000
Received: from magus.postgresql.org ([87.238.57.229])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <dimitri@2ndQuadrant.fr>) id 1Txf6p-0007Pb-O1
	for pgsql-hackers@postgresql.org; Tue, 22 Jan 2013 14:45:55 +0000
Received: from acidenitrix.villemain.org ([91.121.90.165])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <dimitri@2ndQuadrant.fr>) id 1Txf6n-0000nv-Bf
	for pgsql-hackers@postgresql.org; Tue, 22 Jan 2013 14:45:55 +0000
Received: from [89.157.243.170] (helo=Dimitris-MacBook-Air.local)
	by acidenitrix.villemain.org with esmtpsa
	(TLS1.0:DHE_RSA_AES_128_CBC_SHA1:16) (Exim 4.72)
	(envelope-from <dimitri@2ndQuadrant.fr>)
	id 1Txf6l-0001GC-Rj; Tue, 22 Jan 2013 15:45:51 +0100
From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
To: Thom Brown <thom@linux.com>
Cc: Robert Haas <robertmhaas@gmail.com>,
	Alvaro Herrera <alvherre@2ndquadrant.com>,
	PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Event Triggers: adding information
Organization: 2ndQuadrant
References: <m2txrsdzxa.fsf@2ndQuadrant.fr>
	<CA+TgmoZjOACnHOKrz-eucj3FJXrYJzA-_yjSqajOQR8qkjCi=w@mail.gmail.com>
	<m2bodi55yn.fsf@2ndQuadrant.fr>
	<CA+TgmoZTxXGAkoyQD0aNOyju1X19SnVfk7KV9fsJCv63bS-C4g@mail.gmail.com>
	<m27go1ot1a.fsf@2ndQuadrant.fr> <20130104205251.GB9191@alvh.no-ip.org>
	<m28v88pqin.fsf@2ndQuadrant.fr> <20130109165829.GB4490@alvh.no-ip.org>
	<CA+TgmobykpymdGyfbCDEfS6+-50X-AKYTdK88fjMS4-mY5SBdw@mail.gmail.com>
	<m2ehhkrfqk.fsf@2ndQuadrant.fr>
	<CA+TgmobfeB_YpgMv5NjW52tG36Hg_DY=jq0XDkE5zwCstPQ4pg@mail.gmail.com>
	<m2pq14m7sx.fsf@2ndQuadrant.fr>
	<CA+TgmoYEW583z+oisToCYQMz2grzpavdXrCi3-W2D_+nucVhzQ@mail.gmail.com>
	<m2k3rbhh79.fsf@2ndQuadrant.fr>
	<CA+TgmoZYFhn=DyenBLr8KUZXYHtgjo-O8YE-7y61WKR6F05UQA@mail.gmail.com>
	<m21udesaz3.fsf@2ndQuadrant.fr>
	<CA+TgmoZPhj6Rw-DottwresCJnOmRewbOxp2AABwyxP2k7vZf-Q@mail.gmail.com>
	<m2622pmnnn.fsf@2ndQuadrant.fr>
	<CAA-aLv6Q4rtYyGYqp3e6qrikG0azxSYPigydBwwMgk=eBjeawQ@mail.gmail.com>
	<m21uddjqi1.fsf@2ndQuadrant.fr>
	<CAA-aLv4BbPRCNdao_RVa2TNaW8kZxiScTLx5xCuDMnfgPWmXHA@mail.gmail.com>
User-Mail-Address: dimitri@2ndQuadrant.fr
Date: Tue, 22 Jan 2013 15:45:40 +0100
In-Reply-To: 
 <CAA-aLv4BbPRCNdao_RVa2TNaW8kZxiScTLx5xCuDMnfgPWmXHA@mail.gmail.com>
	(Thom Brown's message of "Tue, 22 Jan 2013 13:37:21 +0000")
Message-ID: <m2ip6pi8dn.fsf@2ndQuadrant.fr>
User-Agent: Gnus/5.130006 (Ma Gnus v0.6) Emacs/24.2 (darwin)
MIME-Version: 1.0
Content-Type: text/plain
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-hackers>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-hackers.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@postgresql.org>
List-Post: <mailto:pgsql-hackers@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-hackers>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
X-Mailing-List: pgsql-hackers
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

Thom Brown <thom@linux.com> writes:
> Ah, in that case, the docs are wrong:
> http://www.postgresql.org/docs/devel/static/sql-createeventtrigger.html

Oh. It's missing the comma and applying the AND at the wrong level,
here's a fix:

diff --git a/doc/src/sgml/ref/create_event_trigger.sgml b/doc/src/sgml/ref/create_event_trigger.sgml
index 040df11..3088ffa 100644
--- a/doc/src/sgml/ref/create_event_trigger.sgml
+++ b/doc/src/sgml/ref/create_event_trigger.sgml
@@ -23,7 +23,7 @@ PostgreSQL documentation
 <synopsis>
 CREATE EVENT TRIGGER <replaceable class="PARAMETER">name</replaceable>
   ON <replaceable class="PARAMETER">event</replaceable>
-  [ WHEN <replaceable class="PARAMETER">filter_variable</replaceable> IN (filter_value [ AND ... ] ) ]
+  [ WHEN <replaceable class="PARAMETER">filter_variable</replaceable> IN (filter_value [, ... ]) [ AND ... ] ]
   EXECUTE PROCEDURE <replaceable class="PARAMETER">function_name</replaceable>()
 </synopsis>
  </refsynopsisdiv>

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers