Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oTOZY-0005C6-Oq for pgsql-hackers@arkaria.postgresql.org; Wed, 31 Aug 2022 14:20:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oTOZX-0006kv-Dr for pgsql-hackers@arkaria.postgresql.org; Wed, 31 Aug 2022 14:20:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oTOZV-0006jy-Rp for pgsql-hackers@lists.postgresql.org; Wed, 31 Aug 2022 14:20:03 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oTOZR-0004DT-2D for pgsql-hackers@lists.postgresql.org; Wed, 31 Aug 2022 14:20:01 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id 2494D3200645; Wed, 31 Aug 2022 10:19:53 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Wed, 31 Aug 2022 10:19:53 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ilmari.org; h=cc :cc:content-transfer-encoding:content-type:date:date:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to; s=fm3; t=1661955592; x= 1662041992; bh=zF6othJZrdAzXMEk9GmpioOwDQkMBG5xtpODl38r80g=; b=j 01I3s9XOkF1fouWUHEy5/Lr/Cu0Jq7ZrmGbjBFA9lvAtBSNVPoEZoF5XUKI+Lon1 QYtiAD2GRYsmLielYh+hpob4CxUqhW3VeOATmcmROt63wY91G8reMJ5NKrpz4k4z MBmvXzKpJn96utOPocO91fpgBpIWH/dAKCoBAOaz6FbJAOEo32bBrpCpslV4WPx/ aXEEQ59/pTydUen1ma/Hjg3dgHjGhcB7RTzSFQ5cxuR9wSPwbVOO8BvqOvmRrC92 WGnzWA8brTc48GPCWciX0etAw+X4zzpa6zfh46V8666NTrVq4MP7sZOFEtJmqR+6 aG/lNtpNTwln4T+Irl/IQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1661955592; x= 1662041992; bh=zF6othJZrdAzXMEk9GmpioOwDQkMBG5xtpODl38r80g=; b=l YOMaQ7TyeyLZcoBEMapbIpaNAK3/TpqfbjkAeoJRIdX2i3TBZIuXyk9SXPu+bREw jiEcI/Gk3LeZtqpO+58dOGHXxcWvo7N3ppFEZdbpF13vdiXBUF5la0QsaaT4Qx49 ODHns5ugqo8FccNG+oLbypZIpGmwlIuMS166ufu7RqKMQ+7FDMqd07yGMOv9XUUV vQEZqE52gay1ERXOetFu1nYj4yAObqe+xjCcDjDEwsON2m6S1NdJbIGvGj1pB/xi hfdQ7Mrvq74WI7ckM5ZbAWt3nLH/zmHSlcExOGKgYireEm5zgYUvySrUUzetqwst 4d83JBPh8cRA6TunA5ZjA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrvdekiedggeekucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhephffvvefufhffjgfkfgggtgfgsehtkeertddtreejnecuhfhrohhmpeffrghg fhhinhhnpgfklhhmrghrihgpofgrnhhnshonkhgvrhcuoehilhhmrghrihesihhlmhgrrh hirdhorhhgqeenucggtffrrghtthgvrhhnpeeggeekgfefheelkeeuhfevveektddtfedt ffeuveeujeeftdegtdetffegtdfhleenucevlhhushhtvghrufhiiigvpedtnecurfgrrh grmhepmhgrihhlfhhrohhmpehilhhmrghrihesihhlmhgrrhhirdhorhhg X-ME-Proxy: Feedback-ID: i1ff147bf:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 31 Aug 2022 10:19:51 -0400 (EDT) From: =?utf-8?Q?Dagfinn_Ilmari_Manns=C3=A5ker?= To: Christoph Berg Cc: Daniel Gustafsson , Peter Eisentraut , PostgreSQL Hackers Subject: Re: plpgsql-trigger.html: Format TG_ variables as table (patch) References: <357fec80-cb54-1455-0632-b23d844e5a68@enterprisedb.com> Date: Wed, 31 Aug 2022 15:19:50 +0100 In-Reply-To: (Christoph Berg's message of "Wed, 31 Aug 2022 14:33:24 +0200") Message-ID: <877d2omr5l.fsf@wibble.ilmari.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Christoph Berg writes: > Re: To Daniel Gustafsson >> "string containing" is again pretty boilerplatish, how about just >> "contains"? > > Actually, just omitting the whole prefix works best. > > TG_WHEN (text) > > BEFORE, AFTER, or INSTEAD OF, depending on the trigger's definition. The attached patch does not reflect this, did you attach an old version? > I also shortened some "name of table" to just "table". Since the data > type is "name", it's clear what "table" means. I think it reads better with the definite article and initial capital, e.g. "The table that triggered ….". > > > - NEW > + NEW (record) The type names should still be wrapped in , like they were before. - ilmari