Re: Row pattern recognition

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: jacob(dot)champion(at)enterprisedb(dot)com, vik(at)postgresfriends(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org, er(at)xs4all(dot)nl, peter(at)eisentraut(dot)org
Subject: Re: Row pattern recognition
Date: 2024-05-15 00:02:03
Message-ID: 20240515.090203.2255390780622503596.t-ishii@sranhm.sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Attached are the v19 patches. Changes from v18 include:

0002:
- add a check whether DEFINE clause includes subqueries. If so, error out.
0007:
- fix wrong test (row pattern definition variable name must not appear
more than once)
- remove unnessary test (undefined define variable is not allowed).
We have already allowed the undefined variables.
- add tests: subqueries and aggregates in DEFINE clause are not
supported. The standard allows them but I have not implemented them
yet.

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

Attachment Content-Type Size
v19-0001-Row-pattern-recognition-patch-for-raw-parser.patch text/x-patch 19.9 KB
v19-0002-Row-pattern-recognition-patch-parse-analysis.patch text/x-patch 11.6 KB
v19-0003-Row-pattern-recognition-patch-rewriter.patch text/x-patch 4.1 KB
v19-0004-Row-pattern-recognition-patch-planner.patch text/x-patch 6.7 KB
v19-0005-Row-pattern-recognition-patch-executor.patch text/x-patch 52.8 KB
v19-0006-Row-pattern-recognition-patch-docs.patch text/x-patch 9.7 KB
v19-0007-Row-pattern-recognition-patch-tests.patch text/x-patch 47.1 KB
v19-0008-Allow-to-print-raw-parse-tree.patch text/x-patch 750 bytes

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2024-05-15 00:37:19 Re: First draft of PG 17 release notes
Previous Message Michael Paquier 2024-05-15 00:00:01 Re: pgsql: Fix overread in JSON parsing errors for incomplete byte sequence