Request a Demo
Home   >   mailing lists

Re: Row pattern recognition - Mailing list pgsql-hackers

From Henson Choi
Subject Re: Row pattern recognition
Date
Msg-id CAAAe_zChauRBHQCL+e0DWqDOF41A72hoQ_F1uZb81yzWHD2DFw@mail.gmail.com
Whole thread Raw
In response to Re: Row pattern recognition  (Jacob Champion <jacob.champion@enterprisedb.com>)
Responses Re: Row pattern recognition
List pgsql-hackers
Tree view
Hi Jacob,

Thank you for sharing your dev branch! I extracted test cases from your implementation and found two failing patterns in my executor:

2026년 1월 15일 (목) AM 3:12, Jacob Champion <jacob.champion@enterprisedb.com>님이 작성:
On Sat, Jan 10, 2026 at 1:20 AM Henson Choi <assam258@gmail.com> wrote:
> I'd definitely be interested in seeing it, rough edges and all. I haven't
> tackled the PostgreSQL integration design yet, so understanding how
> preferment rules map to the existing infrastructure would be very helpful.
> (Tatsuo found that email, by the way.)

Yep -- the dev branch link from that email still works, for you and
anyone interested:

    https://github.com/jchampio/postgres/tree/dev/rpr

1. (A | B)+ C with data A, B, A, C

My result: NULL (no match)
Correct: 1-4

2. ((A | B) C)+ with data A, C, B, C, X

My result: 1-2, 3-4 (split matches)
Correct: 1-4
 
--Jacob

Since I implemented the pattern matching and context absorption somewhat naively,
I think these areas will need an overall review. Thanks for the helpful test patterns!

Best regards,
Henson

pgsql-hackers by date:

Previous
From: jian he
Date:
Subject: Re: Enable partitionwise join for partition keys wrapped by RelabelType
Next
From: Sami Imseih
Date:
Subject: Re: Flush some statistics within running transactions