Jul 2026

1 commit
JSON_TABLE PLAN clause
9 Jul 2026Alexander KorotkovmasterunreleasedAlso in: SQL/JSON json_table plan clause (landed as posted)Also in: remaining sql/json patches (not this thread)Also in: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size (not this thread)Also in: SQL/JSON features for v15 (not this thread)

Apr 2024

2 commits
JSON_TABLE: Add support for NESTED paths and columns
8 Apr 2024Amit Langotemaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1Also in: remaining sql/json patches (part of a posted patchset)Also in: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size (not this thread)Also in: SQL/JSON features for v15 (not this thread)
Add basic JSON_TABLE() functionality
4 Apr 2024Amit Langotemaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1Also in: remaining sql/json patches (part of a posted patchset)Also in: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size (not this thread)Also in: SQL/JSON features for v15 (not this thread)

Mar 2024

1 commit
Add SQL/JSON query functions
21 Mar 2024Amit Langotemaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1Also in: remaining sql/json patches (part of a posted patchset)Also in: SQL/JSON revisited (not this thread)Also in: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size (not this thread)Also in: SQL/JSON features for v15 (not this thread)

Jan 2024

3 commits
Refactor code used by jsonpath executor to fetch variables
24 Jan 2024Amit Langotemaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1Also in: remaining sql/json patches (part of a posted patchset)Also in: SQL/JSON revisited (not this thread)Also in: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size (not this thread)Also in: SQL/JSON features for v15 (not this thread)
Adjust populate_record_field() to handle errors softly
24 Jan 2024Amit Langotemaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1Also in: remaining sql/json patches (part of a posted patchset)Also in: SQL/JSON revisited (not this thread)Also in: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size (not this thread)Also in: SQL/JSON features for v15 (not this thread)
Add soft error handling to some expression nodes
24 Jan 2024Amit Langotemaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1Also in: remaining sql/json patches (part of a posted patchset)Also in: SQL/JSON revisited (not this thread)Also in: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size (not this thread)Also in: SQL/JSON features for v15 (not this thread)

Jul 2023

1 commit
Add more SQL/JSON constructor functions
26 Jul 2023Amit Langotemaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1Also in: remaining sql/json patches (part of a posted patchset)Also in: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size (not this thread)Also in: SQL/JSON features for v15 (not this thread)

Mar 2023

2 commits
SQL/JSON: support the IS JSON predicate
31 Mar 2023Alvaro Herreramaster16beta1REL_19_STABLE16beta1REL_18_STABLE16beta1REL_17_STABLE16beta1REL_16_STABLE16beta1Also in: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size (not this thread)Also in: SQL/JSON features for v15 (not this thread)Also in: SQL/JSON in PostgreSQL
LLM analysis, 98% surepart of a posted patchsetmoderate changesfrom patchset #1216 of 9 reviewers saw the final version

Retains the IS JSON component of #121, with revised gram.y precedence, json_validate error handling, node definitions and ecpg coverage. The supplied verdicts in thread #46113 and thread #46380 confirm that their attachments do not implement the predicate, while thread #36156 contains only older submissions.

  • Andres Freundsaw the final versionLLM analysis, 99% sureExplicitly credited as a reviewer in 6ee30209a6, with no predicate-specific review visible here.
  • Pavel Stehulesaw an earlier versionLLM analysis, 98% sureReported clean code and successful testing of the series containing IS JSON in #52 and #54.
  • Andrew Alsupsaw the final versionLLM analysis, 99% sureExplicitly credited as a reviewer in 6ee30209a6, while his visible tests concern query functions.
  • Erik Rijkerssaw an earlier versionLLM analysis, 98% sureReviewed predicate documentation in #74, before later implementation changes.
  • Zhihong Yusaw the final versionLLM analysis, 99% sureExplicitly credited as a reviewer in 6ee30209a6, while his visible detailed reviews address other components.
  • Himanshu Upadhyayasaw an earlier versionLLM analysis, 98% sureTested IS JSON scalar behavior and examples in #100, before later grammar and validation changes.
  • Daniel Gustafssonsaw the final versionLLM analysis, 99% sureExplicitly credited as a reviewer in 6ee30209a6, with no message in this thread.
  • Justin Pryzbysaw the final versionLLM analysis, 99% sureExplicitly credited as a reviewer in 6ee30209a6, while his visible node-failure report concerns constructors.
  • Alvaro Herrerasaw the final versioncommittercommitted the patch
SQL/JSON: add standard JSON constructor functions
29 Mar 2023Alvaro Herreramaster16beta1REL_19_STABLE16beta1REL_18_STABLE16beta1REL_17_STABLE16beta1REL_16_STABLE16beta1Also in: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size (not this thread)Also in: SQL/JSON features for v15 (not this thread)Also in: SQL/JSON in PostgreSQL
LLM analysis, 97% surepart of a posted patchsetsignificant changesfrom patchset #1213 of 10 reviewers saw the final version

The constructors and common clauses from #121 remain identifiable, with JsonConstructorExprState-based execution, revised parser/catalog support and rewritten documentation and ecpg tests. The supplied verdicts in thread #46113 and thread #46380 identify their work as executor-state relocation and query repairs rather than newer constructor submissions; the submissions in thread #36156 predate this source.

  • Andres Freundsaw an earlier versionLLM analysis, 98% sureReported ecpg failures and bison warnings in #113, before the later constructor and shared-infrastructure restructuring.
  • Pavel Stehulesaw an earlier versionLLM analysis, 98% sureTested constructors and drove conventional coercion and node representation in #48, #50 and #54.
  • Andrew Alsupsaw the final versionLLM analysis, 99% sureExplicitly credited as a reviewer in 7081ac46ac, while his visible tests concern query functions.
  • Erik Rijkerssaw an earlier versionLLM analysis, 98% sureSupplied constructor-documentation corrections and tested examples in #74, before later restructuring.
  • Zhihong Yusaw an earlier versionLLM analysis, 98% sureReviewed constructor defaults and uniqueness-aggregation logic in #71.
  • Himanshu Upadhyayasaw an earlier versionLLM analysis, 98% sureTested constructor syntax, key conversion and return behavior in #90, before later restructuring.
  • Daniel Gustafssonsaw the final versionLLM analysis, 99% sureExplicitly credited as a reviewer in 7081ac46ac, with no message in this thread.
  • Justin Pryzbysaw an earlier versionLLM analysis, 98% sureReported JSON_OBJECT raw-expression failures in #117 and #120, before subsequent repairs and restructuring.
  • Tom Lanesaw an earlier versionLLM analysis, 95% sureDiagnosed warnings-as-errors and unused grammar problems and proposed landing dependent grammar together in #112 and #116.
  • Alvaro Herrerasaw the final versioncommittercommitted the patch

Mar - Apr 2022

9 commits
Improve readability of SQL/JSON documentation.
11 Apr 2022Andrew Dunstanmaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1
LLM analysis, 100% surewritten from the discussion, no matching patch1 of 1 reviewer saw the final version

Directly implements Justin Pryzby's prose review #144 in doc/src/sgml/func.sgml, fixing wording and removing the misleading GROUP BY sentence; no matching patch was attached.

  • Justin Pryzbysaw the final versionLLM analysis, 100% sureProposed the wording and GROUP BY corrections in #144 that the commit applies.
Documentation for SQL/JSON features
8 Apr 2022Andrew Dunstanmaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1Also in: SQL/JSON: JSON_TABLE (part of a posted patchset)
LLM analysis, 99% surepart of a posted patchsetmoderate changesfrom patchset #1217 of 10 reviewers saw the final version

The functions and aggregate documentation in doc/src/sgml/func.sgml derives from #121, with consolidation and aggregate-section editing. This agrees with the shared-provenance verdict in thread #38010, which identifies #503176 as the source of the separate 479-line JSON_TABLE section.

  • Andres Freundsaw the final versionLLM analysis, 99% sureExplicitly credited as a reviewer in a6baa4badd, with no documentation-specific review visible here.
  • Alexander Korotkovsaw the final versionLLM analysis, 99% sureExplicitly credited as a reviewer in a6baa4badd, while his visible reviews primarily concern implementation.
  • Pavel Stehulesaw the final versionLLM analysis, 99% sureExplicitly credited as a reviewer in a6baa4badd, with no specific consolidated-documentation review visible here.
  • Andrew Alsupsaw the final versionLLM analysis, 99% sureExplicitly credited as a reviewer in a6baa4badd, while his visible tests concern query behavior.
  • Erik Rijkerssaw an earlier versionLLM analysis, 98% sureRead func.sgml, supplied corrections and ran examples in #74, before consolidation and aggregate editing.
  • Zhihong Yusaw an earlier versionLLM analysis, 98% sureReviewed JSON-type function wording in #82 before further documentation restructuring and is explicitly credited in a6baa4badd.
  • Himanshu Upadhyayasaw an earlier versionLLM analysis, 98% sureChecked documentation examples against actual results in #100, before the consolidated version.
  • Daniel Gustafssonsaw the final versionLLM analysis, 99% sureExplicitly credited as a reviewer in a6baa4badd, with no message in this thread.
  • Justin Pryzbysaw the final versionLLM analysis, 99% sureExplicitly credited as a reviewer in a6baa4badd; his documentation review #144 postdates this landing.
  • Andrew Dunstansaw the final versioncommittercommitted the patch
RETURNING clause for JSON() and JSON_SCALAR()
31 Mar 2022Andrew Dunstanmaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1
LLM analysis, 100% surelanded as postedfrom patchset #12110 of 10 reviewers saw the final version

The RETURNING patch in #121 matches the committed additions/deletions, including parser, raw-node traversal and regression tests.

  • Andres Freundsaw the final versionLLM analysis, 99% sureExplicitly credited in 49082c2cc3; no review of this extracted RETURNING patch is visible here.
  • Alexander Korotkovsaw the final versionLLM analysis, 99% sureExplicitly credited in 49082c2cc3; no review of this extracted RETURNING patch is visible here.
  • Pavel Stehulesaw the final versionLLM analysis, 99% sureExplicitly credited in 49082c2cc3; his visible whole-series testing predates this component.
  • Andrew Alsupsaw the final versionLLM analysis, 99% sureExplicitly credited in 49082c2cc3; his visible tests concern query functions.
  • Erik Rijkerssaw the final versionLLM analysis, 99% sureExplicitly credited in 49082c2cc3; no review of this extracted RETURNING patch is visible here.
  • Zhihong Yusaw the final versionLLM analysis, 99% sureExplicitly credited in 49082c2cc3; no review of this extracted RETURNING patch is visible here.
  • Himanshu Upadhyayasaw the final versionLLM analysis, 99% sureExplicitly credited in 49082c2cc3; his visible reviews concern other components.
  • Daniel Gustafssonsaw the final versionLLM analysis, 99% sureExplicitly credited in 49082c2cc3, with no message in this thread.
  • Justin Pryzbysaw the final versionLLM analysis, 99% sureExplicitly credited in 49082c2cc3; his visible node-failure report specifically concerns constructors.
  • Andrew Dunstansaw the final versioncommittercommitted the patch
SQL JSON functions
30 Mar 2022Andrew Dunstanmaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #1218 of 10 reviewers saw the final version

The JSON/JSON_SCALAR/JSON_SERIALIZE code and tests match #121; only documentation is held for a later commit.

  • Andres Freundsaw the final versionLLM analysis, 99% sureExplicitly credited in 606948b058; no review of these three functions is visible here.
  • Alexander Korotkovsaw the final versionLLM analysis, 99% sureExplicitly credited in 606948b058; his visible review predates these functions.
  • Pavel Stehulesaw the final versionLLM analysis, 99% sureExplicitly credited in 606948b058; his visible whole-series testing predates these functions.
  • Andrew Alsupsaw the final versionLLM analysis, 99% sureExplicitly credited in 606948b058; his visible tests concern query functions.
  • Erik Rijkerssaw an earlier versionLLM analysis, 96% sureSupplied corrections to these functions' documentation in #74, before subsequent node-support repairs.
  • Zhihong Yusaw an earlier versionLLM analysis, 96% sureReviewed execution details in #72 and JSON-type function wording in #82.
  • Himanshu Upadhyayasaw the final versionLLM analysis, 99% sureExplicitly credited in 606948b058; his visible detailed reviews concern other components.
  • Daniel Gustafssonsaw the final versionLLM analysis, 99% sureExplicitly credited in 606948b058, with no message in this thread.
  • Justin Pryzbysaw the final versionLLM analysis, 99% sureExplicitly credited in 606948b058; his visible node-failure report concerns constructors.
  • Andrew Dunstansaw the final versioncommittercommitted the patch
SQL/JSON query functions
29 Mar 2022Andrew Dunstanmaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #1213 of 10 reviewers saw the final version

The query patch from #121 is committed without documentation and with IS_JSON_VALUE/QUERY/EXISTS renamed to JSON_VALUE_OP/QUERY_OP/EXISTS_OP; no other code changes were found.

  • Andres Freundsaw an earlier versionLLM analysis, 96% sureChallenged unsafe PG_TRY/CATCH in #9 and #23, leading to error-handling rework.
  • Alexander Korotkovsaw an earlier versionLLM analysis, 96% sureReviewed subtransaction safety and timezone-dependent immutability in #11 and #56.
  • Pavel Stehulesaw an earlier versionLLM analysis, 96% sureTested query functions and argued parsing errors should precede ON ERROR handling in #39 and #41.
  • Andrew Alsupsaw an earlier versionLLM analysis, 96% sureTested jsonpath slicing and JSON_VALUE equivalence in #26 and #37.
  • Erik Rijkerssaw an earlier versionLLM analysis, 94% sureFound compilation/jumbling problems and checked examples in #45, #74 and the credit in #86.
  • Zhihong Yusaw an earlier versionLLM analysis, 96% sureReviewed executor null/error handling and timezone analysis in #72, prompting logic changes.
  • Himanshu Upadhyayasaw an earlier versionLLM analysis, 96% sureTested JSON_EXISTS and examples in #100, before later copy/equality repairs.
  • Daniel Gustafssonsaw the final versionLLM analysis, 99% sureExplicitly credited in 1a36bc9dba, with no message in this thread.
  • Justin Pryzbysaw the final versionLLM analysis, 99% sureExplicitly credited in 1a36bc9dba; his visible node-failure example concerns constructors.
  • Andrew Dunstansaw the final versioncommittercommitted the patch
IS JSON predicate
28 Mar 2022Andrew Dunstanmaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #1218 of 10 reviewers saw the final version

The IS JSON code and tests from #121 match exactly, with func.sgml changes deferred.

  • Andres Freundsaw the final versionLLM analysis, 99% sureExplicitly credited in 33a377608f; no predicate-specific review is visible here.
  • Alexander Korotkovsaw the final versionLLM analysis, 99% sureExplicitly credited in 33a377608f; no predicate-specific review is visible here.
  • Pavel Stehulesaw an earlier versionLLM analysis, 96% sureReported clean code and successful tests of the series containing IS JSON in #54.
  • Andrew Alsupsaw the final versionLLM analysis, 99% sureExplicitly credited in 33a377608f; his visible tests concern query functions.
  • Erik Rijkerssaw an earlier versionLLM analysis, 96% sureReviewed IS JSON documentation in #74, before later executor/JIT changes.
  • Zhihong Yusaw the final versionLLM analysis, 99% sureExplicitly credited in 33a377608f; his visible detailed reviews concern other components.
  • Himanshu Upadhyayasaw the final versionLLM analysis, 96% sureTested IS JSON scalar behavior and examples in #100; subsequent predicate changes were light.
  • Daniel Gustafssonsaw the final versionLLM analysis, 99% sureExplicitly credited in 33a377608f, with no message in this thread.
  • Justin Pryzbysaw the final versionLLM analysis, 99% sureExplicitly credited in 33a377608f; his visible node-failure report concerns constructors.
  • Andrew Dunstansaw the final versioncommittercommitted the patch
SQL/JSON constructors
27 Mar 2022Andrew Dunstanmaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #1215 of 11 reviewers saw the final version

Constructor code and tests from #121 match exactly; the documentation portion is deferred to a separate commit.

  • Andres Freundsaw the final versionLLM analysis, 96% sureReported ecpg failures and bison warnings in #113 before the combined common-clause/constructor relanding.
  • Alexander Korotkovsaw an earlier versionLLM analysis, 96% sureProposed hash-based uniqueness checking in #56, adopted with later constructor changes.
  • Pavel Stehulesaw an earlier versionLLM analysis, 96% sureTested constructors and drove conventional coercion/node representation in #48, #50 and #54.
  • Andrew Alsupsaw the final versionLLM analysis, 99% sureExplicitly credited in f4fb45d15c; his visible tests concern query functions.
  • Erik Rijkerssaw an earlier versionLLM analysis, 96% sureSupplied constructor-documentation corrections and tested examples in #74.
  • Zhihong Yusaw an earlier versionLLM analysis, 96% sureReviewed constructor defaults and uniqueness-aggregation logic in #71.
  • Himanshu Upadhyayasaw an earlier versionLLM analysis, 96% sureTested constructor syntax, key conversion and return behavior in #90, before node-walker repairs.
  • Daniel Gustafssonsaw the final versionLLM analysis, 99% sureExplicitly credited in f4fb45d15c, with no message in this thread.
  • Justin Pryzbysaw an earlier versionLLM analysis, 96% sureReported JSON_OBJECT raw-expression failures in #117 and #120, fixed in the next version.
  • Tom Lanesaw the final versionLLM analysis, 98% sureDiagnosed warnings-as-errors and proposed landing dependent grammar together in #112 and #116.
  • Andrew Dunstansaw the final versioncommittercommitted the patch
Common SQL/JSON clauses
27 Mar 2022Andrew Dunstanmaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1
LLM analysis, 100% surelanded as postedfrom patchset #1219 of 11 reviewers saw the final version

The common-clause patch in #121 matches exactly and is relanded together with constructors after the initial standalone landing was reverted in #115.

  • Andres Freundsaw the final versionLLM analysis, 96% sureReported ecpg failures and bison warnings in #113 before the combined relanding.
  • Alexander Korotkovsaw the final versionLLM analysis, 99% sureExplicitly credited in f79b803dcc; his visible detailed reviews concern other components.
  • Pavel Stehulesaw an earlier versionLLM analysis, 96% sureReviewed node conventions and reported successful whole-series tests in #52 and #54.
  • Andrew Alsupsaw the final versionLLM analysis, 99% sureExplicitly credited in f79b803dcc; his visible tests concern query functions.
  • Erik Rijkerssaw the final versionLLM analysis, 99% sureExplicitly credited in f79b803dcc; no common-clause-specific review is visible here.
  • Zhihong Yusaw an earlier versionLLM analysis, 96% sureIdentified the missing default error in getJsonEncodingConst and reviewed common-clause code in #71.
  • Himanshu Upadhyayasaw the final versionLLM analysis, 96% sureReviewed format naming and const qualification in #90, followed by light common-clause cleanup.
  • Daniel Gustafssonsaw the final versionLLM analysis, 99% sureExplicitly credited in f79b803dcc, with no message in this thread.
  • Justin Pryzbysaw the final versionLLM analysis, 99% sureExplicitly credited in f79b803dcc; his visible node-failure report concerns constructors.
  • Tom Lanesaw the final versionLLM analysis, 98% sureDiagnosed warnings-as-errors and proposed landing dependent grammar together in #112 and #116.
  • Andrew Dunstansaw the final versioncommittercommitted the patch
Common SQL/JSON clauses
22 Mar 2022Andrew Dunstanmaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1
LLM analysis, 100% surelanded as postedfrom patchset #1096 of 8 reviewers saw the final version

The common-clause patch in #109 matches exactly; #121 postdates this initial landing and cannot be its source.

  • Andres Freundsaw the final versionLLM analysis, 99% sureExplicitly credited in 865fe4d5df; his common-clause build report occurs after this landing.
  • Alexander Korotkovsaw the final versionLLM analysis, 99% sureExplicitly credited in 865fe4d5df; his visible detailed reviews concern other components.
  • Pavel Stehulesaw an earlier versionLLM analysis, 96% sureReviewed node conventions and reported successful whole-series testing in #52 and #54.
  • Andrew Alsupsaw the final versionLLM analysis, 99% sureExplicitly credited in 865fe4d5df; his visible tests concern query functions.
  • Erik Rijkerssaw the final versionLLM analysis, 99% sureExplicitly credited in 865fe4d5df; no common-clause-specific review is visible here.
  • Zhihong Yusaw an earlier versionLLM analysis, 96% sureIdentified missing default error handling in getJsonEncodingConst in #71.
  • Himanshu Upadhyayasaw the final versionLLM analysis, 96% sureReviewed format naming and const qualification in #90, followed by light common-clause cleanup.
  • Andrew Dunstansaw the final versioncommittercommitted the patch

Credits across 19 commits

Author
Nikita Glukhov8 LLM17
Alexander Korotkov9
Amit Langote9
Oleg Bartunov9
Teodor Sigaev9
Andrew Dunstan8
jian he3
Nikita Malakhov1
Peter Eisentraut1
Reviewer
Andrew Dunstancommitter8
Alvaro Herreracommitter3
Andres Freund1
Andrew Alsup1
Daniel Gustafsson1
Erik Rijkers1
Himanshu Upadhyaya1
jian he1
Justin Pryzby1
Pavel Stehule1
Vladlen Popolitov1
Zhihong Yu1
Co author
Alexander Korotkov1
Amit Langote1
Andrew Dunstan1
Anton A. Melnikov1
Nikita Glukhov1
Oleg Bartunov1
Teodor Sigaev1
Committer
Andrew Dunstan9
Amit Langote7
Alvaro Herrera2
Alexander Korotkov1

N LLM means N of the credits come from LLM analysis, not from commit trailers.