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 1jRDUR-0006k5-Oc for pgsql-docs@arkaria.postgresql.org; Wed, 22 Apr 2020 11:24:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jRDUQ-0001Wz-Aj for pgsql-docs@arkaria.postgresql.org; Wed, 22 Apr 2020 11:24:26 +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 1jRCMR-0005Jx-WF for pgsql-docs@lists.postgresql.org; Wed, 22 Apr 2020 10:12:08 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jRCMO-0006vU-0J for pgsql-docs@lists.postgresql.org; Wed, 22 Apr 2020 10:12:06 +0000 Content-Type: multipart/mixed; boundary="===============7653291796121496325==" MIME-Version: 1.0 Subject: filter with json_agg(DISTINCT table.*) behaves differently To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: mihirpmehta@gmail.com Reply-To: mihirpmehta@gmail.com, pgsql-docs@lists.postgresql.org Date: Wed, 22 Apr 2020 10:11:22 +0000 Message-ID: <158755028255.635.4092609317677999644@wrigleys.postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7653291796121496325== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMC9yZWxl YXNlLTEwLTcuaHRtbApEZXNjcmlwdGlvbjoKCkZvbGxvd2luZyBpcyBvdXIgZmluZGluZzogDQoN ClBvc3RncmVzIHF1ZXJ5IGJlaGF2ZXMgZGlmZmVyZW50bHkgaW4gMiB2ZXJzaW9uIA0KDQpTcGVj aWZpY2FsbHkgDQoNCg0KKGpzb25fYWdnKERJU1RJTkNUIHRhYmxlX25hbWUuKikgZmlsdGVyKHdo ZXJlIHRhYmxlX25hbWUgaXMgbm90IG51bGwpKSBhcwp0YWJsZSwNCi4NCi4NCi4NCg0KIGdpdmVz IG51bGwgcmVjb3JkIGluIDEwLjcgd2hlcmUgaXQgZ2l2ZXMgcHJvcGVyIGRhdGEgaW4gMTAuNiAN Cg0KRm9sbG93aW5nIGlzIHRoZSB2ZXJzaW9uIGRpZmZlcmVuY2Ugb2YgcG9zdGdyZXMgDQoNCldP UktJTkcgLSBQb3N0Z3JlU1FMIDEwLjYgb24geDg2XzY0LXBjLWxpbnV4LWdudSwgY29tcGlsZWQg YnkgZ2NjIChHQ0MpCjQuOC4zIDIwMTQwOTExIChSZWQgSGF0IDQuOC4zLTkpLCA2NC1iaXQNCg0K Tk9UIFdPUktJTkcgLSBQb3N0Z3JlU1FMIDEwLjcgb24geDg2XzY0LXBjLWxpbnV4LWdudSwgY29t cGlsZWQgYnkgZ2NjIChHQ0MpCjQuOS4zLCA2NC1iaXQK --===============7653291796121496325==--