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 1lH6cA-0001nz-Pv for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Mar 2021 15:07:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lH6c9-00081h-Nv for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Mar 2021 15:07:09 +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 1lH6c9-00081a-Gp for pgsql-hackers@lists.postgresql.org; Tue, 02 Mar 2021 15:07:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lH6c4-0006x4-5V for pgsql-hackers@lists.postgresql.org; Tue, 02 Mar 2021 15:07:08 +0000 Received: from coridan.postgresql.org ([2001:4800:3e1:1::213]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lH6c3-00018z-Qg for pgsql-hackers@lists.postgresql.org; Tue, 02 Mar 2021 15:07:03 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lH6c2-00040C-Ji for pgsql-hackers@lists.postgresql.org; Tue, 02 Mar 2021 15:07:02 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: GROUP BY DISTINCT To: pgsql-hackers@lists.postgresql.org From: Georgios Kokolatos Cc: Vik Fearing Date: Tue, 02 Mar 2021 15:06:28 +0000 User-Agent: pgcommitfest X-cfsender: gkokolatos In-Reply-To: References: Message-ID: <161469758801.29967.4455067072614569957.pgcf@coridan.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk VGhlIGZvbGxvd2luZyByZXZpZXcgaGFzIGJlZW4gcG9zdGVkIHRocm91Z2ggdGhlIGNvbW1pdGZl c3QgYXBwbGljYXRpb246Cm1ha2UgaW5zdGFsbGNoZWNrLXdvcmxkOiAgbm90IHRlc3RlZApJbXBs ZW1lbnRzIGZlYXR1cmU6ICAgICAgIG5vdCB0ZXN0ZWQKU3BlYyBjb21wbGlhbnQ6ICAgICAgICAg ICBub3QgdGVzdGVkCkRvY3VtZW50YXRpb246ICAgICAgICAgICAgbm90IHRlc3RlZAoKSGksDQoN CnRoaXMgaXMgYSB1c2VmdWwgZmVhdHVyZSwgdGhhbmsgeW91IGZvciBpbXBsZW1lbnRpbmcuIEkg Z2F0aGVyIHRoYXQgaXQgZm9sbG93cyB0aGUgc3RhbmRhcmQsIGlmIHNvLA0KdGhlbiB0aGVyZSBh cmUgZGVmaW5pdGVseSBubyBvYmplY3Rpb25zIGZyb20gbWUuDQoNClRoZSBwYXRjaCBpbiB2ZXJz aW9uIDIsIGFwcGxpZXMgY2xlYW5seSBhbmQgcGFzc2VzIGFsbCB0aGUgdGVzdHMuDQpJdCBjb250 YWlucyBkb2N1bWVudGF0aW9uIHdoaWNoIHNlZW1zIGNvcnJlY3QgdG8gYSBub24gbmF0aXZlIHNw ZWFrZXIuDQoNCkFzIGEgbWlub3IgZ3JpcGUsIEkgd291bGQgbm90ZSB0aGUgYWRkaXRpb24gb2Yg bGlzdF9pbnRfY21wLg0KVGhlIGJsb2NrDQoNCisgICAgICAgICAgICAgICAvKiBTb3J0IGVhY2gg Z3JvdXBzZXQgaW5kaXZpZHVhbGx5ICovDQorICAgICAgICAgICAgICAgZm9yZWFjaChjZWxsLCBy ZXN1bHQpDQorICAgICAgICAgICAgICAgICAgICAgICBsaXN0X3NvcnQobGZpcnN0KGNlbGwpLCBs aXN0X2ludF9jbXApOw0KDQpDYW4gZm9sbG93IHN1aXQgZnJvbSB0aGUgcmVzdCBvZiB0aGUgY29k ZSwgYW5kIGRlZmluZSBhIHN0YXRpYyBjbXBfbGlzdF9pbnRfYXNjKCksIGFzDQppbmRlZWQgdGhl IHNhbWUgcGF0Y2ggZG9lcyBmb3IgY21wX2xpc3RfbGVuX2NvbnRlbnRzX2FzYy4NClRoaXMgaXMg aW5kZWVkIHBvaW50IG9mIHdoaWNoIEkgd2lsbCBub3QgaG9sZCBhIHRvbyBzdHJvbmcgb3Bpbmlv bi4NCg0KT3ZlcmFsbCA6KzE6IGZyb20gbWUuDQoNCkkgd2lsbCBiZSBidW1waW5nIHRvICdSZWFk eSBmb3IgQ29tbWl0dGVyJyB1bmxlc3Mgb2JqZWN0aW9ucy4=