Re: Row pattern recognition

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: david(dot)g(dot)johnston(at)gmail(dot)com, vik(at)postgresfriends(dot)org, jacob(dot)champion(at)enterprisedb(dot)com, er(at)xs4all(dot)nl, peter(at)eisentraut(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Row pattern recognition
Date: 2025-01-11 05:46:11
Message-ID: 20250111.144611.694591446331617280.ishii@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Attached are the v28 patches to implement a subset of Row Pattern
Recognition feature defined in the SQL standard.

In this patch set:

- Reduce the patch size. Comparing with v27, the patch size is trimmed
from 5296 lines down to 5073 lines. This is mainly achieved in the
raw parser patch so that non implemented features are removed from
the grammar file.

- Use newly introduced makeStringInfoExt() instead of makeStringInfo()
in nodeWindowAgg.c, which removes a few unnecessary codes and should
give slightly better performance.

- Fix bugs in the doc and add it more description regarding RPR
syntax.

Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

Attachment Content-Type Size
v28-0001-Row-pattern-recognition-patch-for-raw-parser.patch application/octet-stream 15.2 KB
v28-0002-Row-pattern-recognition-patch-parse-analysis.patch application/octet-stream 10.8 KB
v28-0003-Row-pattern-recognition-patch-rewriter.patch application/octet-stream 3.7 KB
v28-0004-Row-pattern-recognition-patch-planner.patch application/octet-stream 6.6 KB
v28-0005-Row-pattern-recognition-patch-executor.patch application/octet-stream 59.8 KB
v28-0006-Row-pattern-recognition-patch-docs.patch application/octet-stream 10.5 KB
v28-0007-Row-pattern-recognition-patch-tests.patch application/octet-stream 50.6 KB
v28-0008-Row-pattern-recognition-patch-typedefs.list.patch application/octet-stream 1.2 KB
v28-0009-Allow-to-print-raw-parse-tree.patch application/octet-stream 787 bytes

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message jian he 2025-01-11 05:48:27 Re: Non-text mode for pg_dumpall
Previous Message Andrew Kane 2025-01-11 01:00:50 Re: Restore support for USE_ASSERT_CHECKING in extensions only