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 1pmefS-0008AF-6R for pgsql-hackers@arkaria.postgresql.org; Wed, 12 Apr 2023 17:54:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pmefR-0000Mq-23 for pgsql-hackers@arkaria.postgresql.org; Wed, 12 Apr 2023 17:54:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pmefQ-0000Mh-Ox for pgsql-hackers@lists.postgresql.org; Wed, 12 Apr 2023 17:54:00 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pmefN-0003CJ-Qd for pgsql-hackers@postgresql.org; Wed, 12 Apr 2023 17:53:59 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 127655C010C for ; Wed, 12 Apr 2023 13:53:56 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Wed, 12 Apr 2023 13:53:56 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ilmari.org; h=cc :content-transfer-encoding:content-type: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= 1681322036; x=1681408436; bh=7P5PfnxkdBHopI4uMafCbhh9B+2mseyinlt 88A5YC4M=; b=uqBRPbGL4lZq9VnDpzxXfKyVQQ3xqZl7gTuofcGDIkrilsztPU2 5lSZXuNQYsGpeIe4YIfMvoCp3N0Kt97d7WH/03CTEKAmBmIGFHb/XaP29UK41Hs0 dONx2QL2XOqushq6x1z/5k/YLKxz7+9KmqCqZaMNkMA03RXRmM890eLT149F163z owh4/BRo3TKnJSOGx1VbYbsteXFilP5JzAsZS+0zDzewhXGgRsaM5TOlC+4oJqX5 Fun+twh7nf7qAUMU5YHrKtn8JvxrtfWvXt7fm9LjoRiOCSv8Ve2bxwv3wEUmcgit ioA/5V2kSnUOGseWLnR2+YF18zD2wDPA5Gw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :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=fm3; t=1681322036; x= 1681408436; bh=7P5PfnxkdBHopI4uMafCbhh9B+2mseyinlt88A5YC4M=; b=B +bqq7fbjFG2k4vuhnIQXCo6HY/Q+FgGUwAlTVHNvmj74KFkyeziL8QPIF9kVSNJW Fug/rsDM18CWsZB+o135VrnzPKksbke+FNlAIPhZsDEyHG13XGzJG0ZUZtw8nbRV VtwZDdNeEMbJndcUtIJVfDjkxuNqLnNc5+grM7364idEh7GKaPX0ManHAg4cbc1Q QmGyzs5oky26nuaXNmxmB90pQ0tjvLAWX+dBNP0au116AgoDpr/3DAl2YC303yvH /Lf//aSxyma2jlZMytE3uyY2/Bz1zqRAYCxZ6SYZrPa67OY3HNm50Mht3HZw/7wo 9d+NeRKJX23daAt6YrjVw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrvdekiedguddulecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecunecujfgurhephffvufhfffgjkfgfgggtgfesth ekredttderjeenucfhrhhomhepffgrghhfihhnnhcukfhlmhgrrhhiucforghnnhhsnohk vghruceoihhlmhgrrhhisehilhhmrghrihdrohhrgheqnecuggftrfgrthhtvghrnhepvd fhudeihfeljedvjeelfedtteeuheffhffgjefgudffleejvdeukeegtdekhfejnecuffho mhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehilhhmrghrihesihhlmhgrrhhirdhorhhg X-ME-Proxy: Feedback-ID: i1ff147bf:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA for ; Wed, 12 Apr 2023 13:53:55 -0400 (EDT) From: =?utf-8?Q?Dagfinn_Ilmari_Manns=C3=A5ker?= To: pgsql-hackers@postgresql.org Subject: Re: Adding argument names to aggregate functions References: <877cw3jl8y.fsf@wibble.ilmari.org> Date: Wed, 12 Apr 2023 18:53:54 +0100 In-Reply-To: <877cw3jl8y.fsf@wibble.ilmari.org> ("Dagfinn Ilmari =?utf-8?Q?Manns=C3=A5ker=22's?= message of "Mon, 27 Feb 2023 13:22:53 +0000") Message-ID: <87wn2hq959.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 Dagfinn Ilmari Mannsåker writes: > Hi hackers, > > I'm sure I'm not the only one who can never remember which way around > the value and delimiter arguments go for string_agg() and has to look it > up in the manual every time. To make it more convenient, here's a patch > that adds proargnames to its pg_proc entries so that it can be seen with > a quick \df in psql. Added to the 2023-07 commitfest: https://commitfest.postgresql.org/43/4275/ - ilmari