Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1egA0V-0000Pf-VD for pgsql-hackers@arkaria.postgresql.org; Mon, 29 Jan 2018 14:02:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1egA0U-0006bb-Mm for pgsql-hackers@arkaria.postgresql.org; Mon, 29 Jan 2018 14:01:58 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1egA0U-0006b6-1R for pgsql-hackers@lists.postgresql.org; Mon, 29 Jan 2018 14:01:58 +0000 Received: from bay.acenet.us ([173.230.252.50]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1egA0M-0008E9-QJ for pgsql-hackers@lists.postgresql.org; Mon, 29 Jan 2018 14:01:56 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=anastigmatix.net; s=default; h=Content-Transfer-Encoding:Content-Type: In-Reply-To:MIME-Version:Date:Message-ID:From:References:To:Subject:Sender: Reply-To:Cc:Content-ID:Content-Description:Resent-Date:Resent-From: Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help: List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=HfrWIs1bnK3LHjrB/rcTT99TMKRQ5fB+uokroHt1BlE=; b=CFCZFG4eMjKJl+B+Xs6oWIByAp zHpUviDJvGD07udmrwOmqNr6x+GftMvodcHAr4gwnjTP/cRXP2LfOKRULdg/bc6Dm8oF0X+uuItHF 0EpG7DZdkN74DTWpR4/Vv70S1KWD9jx0jniXusL0os+BQT/WLsgrA6U+1Z625e3EWEwQILNewk2tP ADN/lGOXhTW+WfUavdasPYZU/t8ABNXJ37POaeFp/AU/GlJweUobeTE5CgHNPn9t+2z3dW5LFs7WG NbLapfc6yghkAkplJ5AHRywl4Y/RXC/NIKdF93ezP+lYFgJCLsFk7tjKBzu2OzITgGPhpzldkT43d QZquu+GQ==; Received: from [184.19.48.105] (port=34421) by bay.acenet.us with esmtpsa (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128) (Exim 4.89_1) (envelope-from ) id 1egA0K-0049MA-Ag for pgsql-hackers@lists.postgresql.org; Mon, 29 Jan 2018 09:01:49 -0500 Subject: Re: [HACKERS] WIP: Aggregation push-down To: pgsql-hackers@lists.postgresql.org References: <9666.1491295317@localhost> <8160.1493369169@localhost> <29613.1502983342@localhost> <14577.1509723225@localhost> <18007.1513957437@localhost> <20239.1516971866@localhost> <13114.1517214722@localhost> From: Chapman Flack Message-ID: <5A6F294B.8010502@anastigmatix.net> Date: Mon, 29 Jan 2018 09:01:47 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.7.0 MIME-Version: 1.0 In-Reply-To: <13114.1517214722@localhost> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-OutGoing-Spam-Status: No, score=-100.2 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - bay.acenet.us X-AntiAbuse: Original Domain - lists.postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - anastigmatix.net X-Get-Message-Sender-Via: bay.acenet.us: authenticated_id: chap+anastigmatix.net/only user confirmed/virtual account not confirmed X-Authenticated-Sender: bay.acenet.us: chap@anastigmatix.net X-Source: X-Source-Args: X-Source-Dir: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 01/29/18 03:32, Antonin Houska wrote: > Robert Haas wrote: >>> only take place if we had a special equality operator which distinguishes the >>> *binary* values (I don't know yet how to store this operator the catalog --- ... >> We don't have an operator that tests for binary equality, but it's >> certainly testable from C; see datumIsEqual. Disclaimer: I haven't been following the whole thread closely. But could there be some way to exploit the composite-type *= operator? https://www.postgresql.org/docs/current/static/functions-comparisons.html#COMPOSITE-TYPE-COMPARISON -Chap