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 1qJD7n-00083H-Hj for pgsql-docs@arkaria.postgresql.org; Tue, 11 Jul 2023 13:09:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qJD7m-0003lD-DE for pgsql-docs@arkaria.postgresql.org; Tue, 11 Jul 2023 13:09:50 +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 1qHg0g-00040J-So for pgsql-docs@lists.postgresql.org; Fri, 07 Jul 2023 07:36:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qHg0b-002gpe-MF for pgsql-docs@lists.postgresql.org; Fri, 07 Jul 2023 07:36:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=kSknZYJ+V/bNvSzWVwgKEcKJs2Sua9eOFJEe6FEWWrs=; b=mhE4J4I63rpuWMHHPtNiL/FURX zt0KugX+1CsDPealI1YYgTV+P+f5WMeqVeF4yIlCwkH2gM7exBLqZz1XBafeWAyWLtkhJEAGKgnXK 5t//IM/4Rc0R482gxKnPeqvH4jQx1eY8mcgM9DuVPwLrZJ23JjHghb0kvJ+FkfMvGlS7HjFygQRVd AR9CKg+Oz/wkCv1ByXVtEruiEtcKMlo6vkTAZte//Ymu7jF5AarEJELLZfgUiFGMEK7jVVhMqs0gh uc4wxZtaD17cows5hw2Me33a5EjTQlJX2RY3HLGJlD+5qHFbhY4LRrHpHc5v6lyuXUI76xgwxtp65 zzA73o4Q==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qHg0a-0000ct-5P for pgsql-docs@lists.postgresql.org; Fri, 07 Jul 2023 07:36:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qHg0X-007a4u-VA for pgsql-docs@lists.postgresql.org; Fri, 07 Jul 2023 07:36:02 +0000 Content-Type: multipart/mixed; boundary="===============9052830962957001522==" MIME-Version: 1.0 Subject: group by can use alias from select list To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: postgres-hape@gmx.de Reply-To: postgres-hape@gmx.de, pgsql-docs@lists.postgresql.org Date: Fri, 07 Jul 2023 07:36:00 +0000 Message-ID: <168871536004.379168.9352636188330923805@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============9052830962957001522== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xNS9zcWwt c2VsZWN0Lmh0bWwKRGVzY3JpcHRpb246CgpoaQ0KaSBoYXZlIGEgZGlzY3Vzc2lvbiBpbiBwZ3Nx bC1idWdzQGxpc3RzLnBvc3RncmVzcWwub3JnIGFib3V0IHRoaXMgYW5kIGl0IGlzCm1lbnRpb25l ZCBpbiB0aGUgYW5zd2VycyB0aGF0IGl0IGlzIGRvY3VtZW50ZWQgYW5kIGEgImZlYXR1cmUiIG9m IFBvc3RncmVzCnRoYXQgdGhpcyBjYW4gYmUgZG9uZS4NCklmIHRoaXMgaXMgd2FudGVkIHRoZSBk b2N1bWVudGF0aW9uCihodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzL2N1cnJlbnQvc3Fs LXNlbGVjdC5odG1sKSB0aGF0IG1lbnRpb25lZDoNCiINCkRlc2NyaXB0aW9uDQpTRUxFQ1QgcmV0 cmlldmVzIHJvd3MgZnJvbSB6ZXJvIG9yIG1vcmUgdGFibGVzLiBUaGUgZ2VuZXJhbCBwcm9jZXNz aW5nIG9mClNFTEVDVCBpcyBhcyBmb2xsb3dzOg0KDQoxLikgQWxsIHF1ZXJpZXMgaW4gdGhlIFdJ VEggbGlzdCBhcmUgY29tcHV0ZWQuIFRoZXNlIGVmZmVjdGl2ZWx5IHNlcnZlIGFzCnRlbXBvcmFy eSB0YWJsZXMgdGhhdCBjYW4gYmUgcmVmZXJlbmNlZCBpbiB0aGUgRlJPTSBsaXN0LiBBIFdJVEgg cXVlcnkgdGhhdAppcyByZWZlcmVuY2VkIG1vcmUgdGhhbiBvbmNlIGluIEZST00gaXMgY29tcHV0 ZWQgb25seSBvbmNlLCB1bmxlc3Mgc3BlY2lmaWVkCm90aGVyd2lzZSB3aXRoIE5PVCBNQVRFUklB TElaRUQuIChTZWUgV0lUSCBDbGF1c2UgYmVsb3cuKQ0KDQoyLikgQWxsIGVsZW1lbnRzIGluIHRo ZSBGUk9NIGxpc3QgYXJlIGNvbXB1dGVkLiAoRWFjaCBlbGVtZW50IGluIHRoZSBGUk9NCmxpc3Qg aXMgYSByZWFsIG9yIHZpcnR1YWwgdGFibGUuKSBJZiBtb3JlIHRoYW4gb25lIGVsZW1lbnQgaXMg c3BlY2lmaWVkIGluCnRoZSBGUk9NIGxpc3QsIHRoZXkgYXJlIGNyb3NzLWpvaW5lZCB0b2dldGhl ci4gKFNlZSBGUk9NIENsYXVzZSBiZWxvdy4pDQoNCjMuKSBJZiB0aGUgV0hFUkUgY2xhdXNlIGlz IHNwZWNpZmllZCwgYWxsIHJvd3MgdGhhdCBkbyBub3Qgc2F0aXNmeSB0aGUKY29uZGl0aW9uIGFy ZSBlbGltaW5hdGVkIGZyb20gdGhlIG91dHB1dC4gKFNlZSBXSEVSRSBDbGF1c2UgYmVsb3cuKQ0K DQo0LikgSWYgdGhlIEdST1VQIEJZIGNsYXVzZSBpcyBzcGVjaWZpZWQsIG9yIGlmIHRoZXJlIGFy ZSBhZ2dyZWdhdGUgZnVuY3Rpb24KY2FsbHMsIHRoZSBvdXRwdXQgaXMgY29tYmluZWQgaW50byBn cm91cHMgb2Ygcm93cyB0aGF0IG1hdGNoIG9uIG9uZSBvciBtb3JlCnZhbHVlcywgYW5kIHRoZSBy ZXN1bHRzIG9mIGFnZ3JlZ2F0ZSBmdW5jdGlvbnMgYXJlIGNvbXB1dGVkLiBJZiB0aGUgSEFWSU5H CmNsYXVzZSBpcyBwcmVzZW50LCBpdCBlbGltaW5hdGVzIGdyb3VwcyB0aGF0IGRvIG5vdCBzYXRp c2Z5IHRoZSBnaXZlbgpjb25kaXRpb24uIChTZWUgR1JPVVAgQlkgQ2xhdXNlIGFuZCBIQVZJTkcg Q2xhdXNlIGJlbG93LikNCg0KNS4pIFRoZSBhY3R1YWwgb3V0cHV0IHJvd3MgYXJlIGNvbXB1dGVk IHVzaW5nIHRoZSBTRUxFQ1Qgb3V0cHV0IGV4cHJlc3Npb25zCmZvciBlYWNoIHNlbGVjdGVkIHJv dyBvciByb3cgZ3JvdXAuIChTZWUgU0VMRUNUIExpc3QgYmVsb3cuKQ0KIg0KaXNuJ3QgY29ycmVj dCBiZWNhdXNlIGhvdyAgY2FuIDQuKSBiZSBkb25lIGFuZCB0aGUgYWxpYXMgZnJvbSA1LikgaXMg dXNlZD8KSGVyZSBpcyBhIGhpbnQgaW1wb3J0YW50IHRoYXQgdGhlcmUgaXMgYW4gZXhjZXB0aW9u IGZvciBhbGlhcyB1c2VkIGluIGdyb3VwCmJ5DQoNCnRoZSBTUUwgZm9yIHRoYXQ6DQoNCndpdGgg dGJhc2UoaWQpDQphcyAoc2VsZWN0IDEgdW5pb24gYWxsIHNlbGVjdCAyKQ0Kc2VsZWN0IGlkIG90 dG8gZnJvbSB0YmFzZQ0KZ3JvdXAgYnkgb3R0bw0Kb3JkZXIgYnkgb3R0bw0KDQp3aGF0IGRvIHlv dSB0aGluayBhYm91dCB0aGF0Pw0KaGFwZQo= --===============9052830962957001522==--