Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qMzhN-003nNw-B9 for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Jul 2023 23:38:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qMzhK-00A72O-E5 for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Jul 2023 23:38:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qMzhK-00A72F-4i for pgsql-hackers@lists.postgresql.org; Fri, 21 Jul 2023 23:38:10 +0000 Received: from relay8-d.mail.gandi.net ([217.70.183.201]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qMzhD-0011TJ-VO for pgsql-hackers@postgresql.org; Fri, 21 Jul 2023 23:38:09 +0000 Received: by mail.gandi.net (Postfix) with ESMTPSA id 5359E1BF205; Fri, 21 Jul 2023 23:38:02 +0000 (UTC) Message-ID: <2c25adf7-ee4c-9406-ddfc-4f94643dbfa8@postgresfriends.org> Date: Sat, 22 Jul 2023 01:38:01 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.13.0 Subject: Re: Row pattern recognition To: Jacob Champion , Tatsuo Ishii Cc: pgsql-hackers@postgresql.org References: <90bff6fa-01b7-cf60-f4f4-3412514a7cd2@postgresfriends.org> <20230628.095819.1123345378945479712.t-ishii@sranhm.sra.co.jp> <07214b3a-5893-f6ce-ef55-0e5d24c94925@timescale.com> <20230720.141513.1986681389874528348.t-ishii@sranhm.sra.co.jp> <022a392f-2a9e-3df1-a509-a5bd51160fa5@timescale.com> <69272b9d-1985-9902-0632-e29180c158ae@postgresfriends.org> <862cff51-eaf6-3fa1-07a5-9666c7e4e897@timescale.com> From: Vik Fearing Content-Language: en-US In-Reply-To: <862cff51-eaf6-3fa1-07a5-9666c7e4e897@timescale.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-GND-Sasl: vik@postgresfriends.org List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 7/22/23 01:14, Jacob Champion wrote: > On 7/20/23 17:07, Vik Fearing wrote: >> On 7/21/23 01:36, Jacob Champion wrote: >>> (I've attached two failing tests against v2, to hopefully better >>> illustrate, along with what I_think_ should be the correct results.) >> >> Almost. You are matching 07-01-2023 but the condition is "price > 100". > > D'oh. Correction attached. I think :) This looks correct to my human brain. Thanks! -- Vik Fearing