Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h5Rs8-0006yA-Hn for pgsql-hackers@arkaria.postgresql.org; Sun, 17 Mar 2019 09:14:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h5Rs7-0001NG-1x for pgsql-hackers@arkaria.postgresql.org; Sun, 17 Mar 2019 09:14:23 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h5Rs6-0001N9-Mv for pgsql-hackers@lists.postgresql.org; Sun, 17 Mar 2019 09:14:22 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h5Rs0-0005ZR-0T for pgsql-hackers@lists.postgresql.org; Sun, 17 Mar 2019 09:14:21 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 4B59821144; Sun, 17 Mar 2019 05:14:15 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Sun, 17 Mar 2019 05:14:15 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=hIoxOMEfdce3EHbX3PIOJxhZi/V s19egyjGdV+DYtDE=; b=VBapRNSWWV+yVwlNJYmaJ86HAptvDsc34q0cS5TUvPj nWDqiJR5n5/iRCkHLrfJVEE2Dfh/wbOfvFkQkM2j3IhJ18eeToEqMpuDQvk2JPeb Mt7tneZ+SjD3ZRvIINdkvlT42HpWCgPviWxP9NtV3mRol41jizL0HVCwyTVh7tn6 5sQXNUeUv7WxoL42NeUMYlFX59hrjS1bOEyIS4NdClJKphNeoDBgl28Qg7wFwuzf 2y5hxclY/ORqsaCBlWPnZNPzZSPloj/pPS7TB4MoTPmI7cTWo1iKJljxnhf57NAA DzY607HXpwvptkNHz8MXn2P+g8cUHRK8WhMVuYx6poQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=hIoxOM Efdce3EHbX3PIOJxhZi/Vs19egyjGdV+DYtDE=; b=eWxhTsOUainQEGFAjOdmMJ XPzPq0bdWZZwwo/UqOPcKgtPWy5QNCtlY4IUyjhk5ROsXM07JauHggRHvF9l5uKD UC/ABpZ+geXdwIWFoDfIOaM2nQyKgmBAu3YFsrav8uhzrAq9dEStspGfK9xfQhGh AYq88BiL+/oOy21JJdQaoTRcwOJ/nLBrmi5O0anEsr38js8zbIqrs80wMAa0Zdm1 nFMnjKfsjPEDznr8l6RYfNMuz+zCMmxXp5TlzQIuLDXC0zqwCEFVBK09eYb+tpZU KU+02AyeLKdvgZ8QA6hxYXOAXs/HfrmloZhWcl5LbEJOGUIv5Q7SC/4RseXlI5Hw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedutddrheelgddtfecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdefhedmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenucfk phepiedurddvudehrddufeejrdduiedvnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmih gthhgrvghlsehprghquhhivghrrdighiiinecuvehluhhsthgvrhfuihiivgeptd X-ME-Proxy: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id 52AB3E44A3; Sun, 17 Mar 2019 05:14:13 -0400 (EDT) Date: Sun, 17 Mar 2019 18:14:10 +0900 From: Michael Paquier To: Andrew Gierth Cc: pgsql-hackers@lists.postgresql.org Subject: Re: CREATE OR REPLACE AGGREGATE? Message-ID: <20190317091410.GD3357@paquier.xyz> References: <8736nm55gv.fsf@news-spur.riddles.org.uk> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="10jrOL3x2xqLmOsH" Content-Disposition: inline In-Reply-To: <8736nm55gv.fsf@news-spur.riddles.org.uk> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --10jrOL3x2xqLmOsH Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sun, Mar 17, 2019 at 07:35:16AM +0000, Andrew Gierth wrote: > I took a bash at actually writing it and didn't see any obvious problems > (I'll post the patch in a bit). Is there some reason (other than > shortage of round tuits) why this might not be a good idea, or why it > hasn't been done before? Indeed. There is not much on the matter in pgsql-hackers as far as I can see, except that but the thread is short: https://www.postgresql.org/message-id/CAGYyBgj3u_4mfTNPMnpOM2NPtWQVPU4WRsYz=RLCF59g-kGVmQ@mail.gmail.com -- Michael --10jrOL3x2xqLmOsH Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlyOD+IACgkQnvQgOdby QH3evg//bueH48rNB3vqPWhrXp+twuYiktp8C+M65VH5qO9zZLpxb5K/95QTDpUk oU8QAXf21CllFsF1qzmHLQcApj4JmHmXTQlUcQx9VH+crzQD7p3spSjuF3i9Rqp8 3ci/0ebv9Frjs1eaqsdigCltuFvz1fWDJTvBTCdqYmSwg1bQ9wFNTNjV+OGZQlMD SDUKSDs5Tzl16DXJU0dWTp98SYA/QWMuMGVeOLigY6vpzwT2nN+zO5caIXhvMZPG 6SD/eDrxdLmql5eEACMuEVeYGaVJeRF/m+jQADJMAUtfL91yUW2QYnOCmvismaNm nZucMOlBvj/QC/HH0mOkGov51rLYXmF6lRsfMYNH+g2owF2dhOP5r7ZOxd4xkaiw O2xigwEddggM6LtfveTN22/Y1uXhLhsiIeUE4Bc5flmg+lfxzk+OqnwoeyjpMqqR 1n5o4r3mapn1LjWVkHU6A9L122QxyGrSYmvnx56a7FWkMYjDTBYReQ3VMd0xh2TO vZhGepKS0Fjn3tPe3gP1cGPwLHuxwFPrbjM+VnAaAwMtXFGoq+398thQJZKmK6IZ 5sQYrjQ1LiOoSKLv+575dym97JQI9Pzn5D/RUUryml4ksXO0XEvrJLPV+oo2Fo9+ 06D/4wvOVKgsVz8oX9L+iyjuWFN91Zjs61dYhsjLK1Q5YP9j1I8= =OdmK -----END PGP SIGNATURE----- --10jrOL3x2xqLmOsH--