Message-ID: <69272b9d-1985-9902-0632-e29180c158ae@postgresfriends.org>
Date: Fri, 21 Jul 2023 02:07:44 +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 <jchampion@timescale.com>,
 Tatsuo Ishii <ishii@sraoss.co.jp>
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>
From: Vik Fearing <vik@postgresfriends.org>
Content-Language: en-US
In-Reply-To: <022a392f-2a9e-3df1-a509-a5bd51160fa5@timescale.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/69272b9d-1985-9902-0632-e29180c158ae%40postgresfriends.org>
Precedence: bulk

On 7/21/23 01:36, Jacob Champion wrote:
> There's also the issue of backtracking in the face of reclassification,
> as I think Vik was alluding to upthread.

We definitely need some kind of backtracking or other reclassification 
method.

> (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".
-- 
Vik Fearing