Re: Row pattern recognition

From: Henson Choi <assam258(at)gmail(dot)com>
To: Tatsuo Ishii <ishii(at)postgresql(dot)org>, peter(at)eisentraut(dot)org, vik(at)postgresfriends(dot)org, zsolt(dot)parragi(at)percona(dot)com, er(at)xs4all(dot)nl, li(dot)evan(dot)chao(at)gmail(dot)com
Cc: Jacob Champion <jacob(dot)champion(at)enterprisedb(dot)com>, david(dot)g(dot)johnston(at)gmail(dot)com, 장성준 <sjjang112233(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Row pattern recognition
Date: 2026-05-03 05:34:47
Message-ID: CAAAe_zAMKtkv4i5nFhChPwR6xOjkh9sLfzSS7nW-agZwBcuHSQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Tatsuo, hi hackers,

I'd like to ask for a bit of review help before PGConf.dev 2026
(Vancouver, May 19–22).

For the SQL/RPR R020 poster going on display at the conference, I
have prepared a companion deep-dive page to sit behind the on-site
QR code, building on the patch series Tatsuo has been driving in
this thread:

https://assam258-5892.github.io/postgresql/rpr/

It walks through the standard scope (R010 vs R020), worked examples,
NFA semantics, navigation functions, parser-to-executor design and
pruning rules, plus an interactive NFA simulator. To widen reach,
the page is also available in 23 AI-pretranslated languages from
the switcher:
العربية, Čeština, Dansk, Deutsch, Español, Suomi, Français,
עברית, Magyar, Italiano, 日本語, 한국어, Nederlands, Norsk,
Polski, Português (BR), Română, Русский, Slovenčina, Svenska,
Türkçe, 中文 (简体), 繁體中文.
Each translated page carries a clear "AI pre-translated, errors
possible" notice.

The ask (light, entirely optional):

- English original has had one review pass; Korean I reviewed
myself.
- Tatsuo — if you ever find a free moment, a quick glance at the
Japanese version would be very much appreciated, but absolutely
no rush.
- Native speakers of any of the other 22 languages — incidental
corrections welcome (this thread or off-list), but nothing is
expected.

References (also linked from the deep-dive page):
- thread:
https://www.postgresql.org/message-id/flat/20230625.210509.1276733411677577841.t-ishii%40sranhm.sra.co.jp
- latest patch (v47):
https://postgr.es/m/20260502.140304.670813149418899420.ishii@postgresql.org
- commitfest #4460: https://commitfest.postgresql.org/patch/4460/

Best regards,
Henson

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message jian he 2026-05-03 04:48:52 UPDATE/DELETE FOR PORTION OF fire FOR EACH STATEMENT more than once