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: functions (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: functions (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: functions (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: functions (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: functions (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: functions (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: functions (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: functions (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: functions (part of a posted patchset)Also in: SQL/JSON in PostgreSQL
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: functions (part of a posted patchset)Also in: SQL/JSON in PostgreSQL

Sep 2022

1 commit
Revert SQL/JSON features
1 Sep 2022Andrew Dunstanmaster16beta1REL_19_STABLE16beta1REL_18_STABLE16beta1REL_17_STABLE16beta1REL_16_STABLE16beta1REL_15_STABLE15beta4revert
LLM analysis, 100% surewritten from the discussion, no matching patch2 of 2 reviewers saw the final version

#78 explicitly requests the SQL/JSON revert, Andrew Dunstan accepts in #82, and confirms completion in #90 immediately after this commit. The diff removes the feature family and associated infrastructure rather than applying any repair attachment.

  • Tom Lanesaw the final versionLLM analysis, 90% sureArgued in #75 that the revert should cover HEAD as well as PostgreSQL 15, shaping the committed revert's scope.
  • Bruce Momjiansaw the final versionLLM analysis, 82% sureExplicitly endorsed removing the features from both PostgreSQL 15 and master in #84, before the revert.

Credits across 11 commits

Author
Alexander Korotkov9
Amit Langote9
Nikita Glukhov9
Oleg Bartunov9
Teodor Sigaev9
Andrew Dunstan8
jian he3
Nikita Malakhov1
Peter Eisentraut1
Reviewer
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
Amit Langote7
Alvaro Herrera2
Alexander Korotkov1
Andrew Dunstan1