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: SQL/JSON features for v15 (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: SQL/JSON features for v15 (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: SQL/JSON features for v15 (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: SQL/JSON features for v15 (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: SQL/JSON features for v15 (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: SQL/JSON features for v15 (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: SQL/JSON features for v15 (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: SQL/JSON features for v15 (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: SQL/JSON features for v15 (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: SQL/JSON features for v15 (not this thread)Also in: SQL/JSON: functions (part of a posted patchset)Also in: SQL/JSON in PostgreSQL

Feb 2023

1 commit
Add static assertion ensuring sizeof(ExprEvalStep) <= 64 bytes
22 Feb 2023Andres Freundmaster16beta1REL_19_STABLE16beta1REL_18_STABLE16beta1REL_17_STABLE16beta1REL_16_STABLE16beta1
LLM analysis, 100% surelanded as postedfrom patchset #691 of 1 reviewer saw the final version

The sole hunk in src/include/executor/execExpr.h exactly matches #69, including the comment and StaticAssertDecl. Andres confirms the push in #70; Tom Lane is the submitting author.

  • Andres Freundsaw the final versioncommittercommitted the patch

Jul 2022

3 commits
Remove size increase in ExprEvalStep caused by hashed saops
6 Jul 2022David Rowleymaster16beta1REL_19_STABLE16beta1REL_18_STABLE16beta1REL_17_STABLE16beta1REL_16_STABLE16beta1REL_15_STABLE15beta3
LLM analysis, 100% suremodified before commitmoderate changesfrom patchset #270 of 1 reviewer saw the final version

Matches the revised hashed-array patch in #27, with hash_finfo and trailing FunctionCallInfoBaseData embedded in ScalarArrayOpExprHashTable and allocated together using palloc0. David describes these final edits in #32, and the commit credits both Andres and David.

  • James Colemansaw an earlier versionLLM analysis, 95% sureSaid the initial size-reduction patch looked reasonable in #12, before hash-state relocation and allocation changes.
pgstat: reduce timer overhead by leaving timer running.
5 Jul 2022Andres Freundmaster16beta1REL_19_STABLE16beta1REL_18_STABLE16beta1REL_17_STABLE16beta1REL_16_STABLE16beta1REL_15_STABLE15beta3
LLM analysis, 100% surepart of a posted patchsetmoderate changesfrom patchset #192 of 2 reviewers saw the final version

Commits the statistics-timer member of #19, retaining the timer across commands and checking true idleness in ProcessInterrupts(). It adds an explicit get_timeout_active() guard instead of relying on the separate disable_timeout() fast path, as explained in #30.

  • Tom Lanesaw the final versionLLM analysis, 94% sureProposed retaining an active timeout in #13 and rejected stale caller-supplied timestamps in #17, shaping the committed approach before an attachment existed.
  • Kyotaro Horiguchisaw the final versionLLM analysis, 86% sureEndorsed leaving the timer active as the feasible fix in #9, before the implementation was attached.
expression eval: Fix EEOP_JSON_CONSTRUCTOR and EEOP_JSONEXPR size.
5 Jul 2022Andres Freundmaster16beta1REL_19_STABLE16beta1REL_18_STABLE16beta1REL_17_STABLE16beta1REL_16_STABLE16beta1REL_15_STABLE15beta3
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #191 of 1 reviewer saw the final version

Commits only the JSON-state relocation member of #19, moving JsonConstructorExprState and JsonExprState out of ExprEvalStep. Differences are formatting, placement of an initialization assignment and additions to src/tools/pgindent/typedefs.list; #25's FmgrInfo-pointer change is absent.

  • Andrew Dunstansaw the final versiontrailerReported reviewing the JSON fix with colleagues and finding it sound in #20, after which only light changes reached this commit.

Credits across 14 commits

Author
Alexander Korotkov9
Amit Langote9
Nikita Glukhov9
Oleg Bartunov9
Teodor Sigaev9
Andrew Dunstan8
Andres Freund3
jian he3
David Rowley1
Nikita Malakhov1
Peter Eisentraut1
Tom Lane1
Reviewer
Alvaro Herreracommitter3
Andres Freundcommitter2
Andrew Alsup1
Andrew Dunstan1
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
Andres Freund3
Alvaro Herrera2
Alexander Korotkov1
David Rowley1