Chris van Eijk: invalid input syntax for type JSON in PostgreSQL, measured
Comments on “Chris van Eijk: invalid input syntax for type JSON in PostgreSQL, measured”
Claim-checked. Scored by all three judges, and its checkable claims were compared with the sources it cites. How far stories are checked
Chris van Eijk of Now-Next tested "invalid input syntax for type json" on PostgreSQL 16.15, 17.11 and 18.6. Messages and SQLSTATE were identical across versions, but node-postgres sends a JavaScript array as a Postgres array literal, so [1, 2] fails and [] is stored silently as {}. IS JSON accepts three inputs that jsonb rejects, so use pg_input_is_valid. On 18.6, an immutable SQL-function guard failed in a session's first five calls; PL/pgSQL held up. These are single-run measurements, and the planner explanation is the author's inference.
Why it ranked
No. 9 of 142 with a score of 0.70. The panel rated it highest on technical depth (0.96) and substantiated (0.93), lowest on significance (0.53). Placed No. 9, No. 13 by score alone: the placement terms moved other stories past it.
- AI judgeJudge 2claude-haiku-5-5
- Detailed, heavily measured PostgreSQL JSON error analysis across drivers and versions; highly practical and technically deep, though niche in audience and largely a reference-style writeup rather than major news.
- AI judgeJudge 3gpt-5.6-luna
- A highly reproducible PostgreSQL investigation with extensive measurements, driver comparisons, migration pitfalls, SQLSTATE details, and a PostgreSQL 18 planner regression. It is directly actionable for database and application engineers, though its scope is mainly PostgreSQL users.
Each judge wrote its line after answering the rubric, with the site and the author still hidden. Every answer behind this is in the table under Score.
Score
0.70total under rubric v2.3
- Significance0.53
- Reader interest0.76
- Audience breadth0.56
- Practical relevance0.88
- Substantiated0.93
- Technical depth0.96
- New information0.74
- Counts against: Promotional0.03
- Counts against: Overclaim0.15
Each judge’s answer per question (0–1), their mean and spread, and what the question adds to the score (weight × mean).
| Question | Judge 1 | Judge 2 | Judge 3 | Mean | Spread | Weight | Contribution (weight times mean) |
|---|---|---|---|---|---|---|---|
| SignificanceHow much does this change what people in tech know or can do? | 0.56 | 0.40 | 0.62 | 0.53 | 0.22 | +0.24 | +0.126 |
| Reader interestWould a well-informed senior engineer or tech founder want to read this today, and likely pass it on? | 0.69 | 0.70 | 0.88 | 0.76 | 0.19 | +0.26 | +0.197 |
| Audience breadthHow many people who build technology does it concern? | 0.58 | 0.60 | 0.50 | 0.56 | 0.10 | +0.13 | +0.073 |
| Practical relevanceHow useful is it to someone who builds software or tech products? | 0.92 | 0.85 | 0.86 | 0.88 | 0.07 | +0.22 | +0.193 |
| SubstantiatedHow well is it backed? Consider whether it is the primary source, and whether its main claims come with data, code, a demo, a reproducible method or citations. | 0.99 | 0.90 | 0.90 | 0.93 | 0.09 | +0.05 | +0.047 |
| Technical depthHow technically substantive is it? | 1.00 | 0.95 | 0.94 | 0.96 | 0.06 | +0.05 | +0.048 |
| New informationDoes it contain information absent from the stories covered in the last 7 days (list provided)? | 0.79 | 0.60 | 0.83 | 0.74 | 0.23 | +0.05 | +0.037 |
| PromotionalIs it mainly marketing with little substance (a press release, ad or sponsored post with no real information)? A launch post that carries real news is not promotional. | 0.03 | 0.05 | 0.01 | 0.03 | 0.04 | −0.19 | −0.006 |
| OverclaimDo the headline or conclusions claim more than the body supports? | 0.14 | 0.20 | 0.12 | 0.15 | 0.08 | −0.11 | −0.017 |
| Sum of contributions | +0.697 | ||||||
| Claim-check penalty | 0.000 | ||||||
| Total, as published | 0.697 | ||||||
Spread is the highest minus the lowest judge answer. marks a spread above 0.40: the judges disagree, and the story is marked contested.
The badge for this ranking, for the author's page or anyone's: one line of HTML, and it links back here.
<a href="https://rubric.hrih.si/editions/2026-11-18/9/"><img src="https://rubric.hrih.si/badge/2026-11-18/9.svg" alt="Ranked #9 on Rubric, 18 Nov 2026" width="238" height="28"></a>Claim check
Claim check: 4 matches source · 2 no source given · 2 couldn’t check. Each claim is compared with the source the article itself cites; a flag is published only when both checkers agree.
Couldn’t checkQuote
The PostgreSQL 18 release notes list the improvement to SQL-language function plan caching under the optimizer section, not under incompatibilities.
The source was unreachable, paywalled or too long, or the two checkers disagreed.
The article says “Improve SQL-language function plan caching”
The source says No passage could be compared.
Source cited by the article: postgresql.org/docs/18/release-18.html
Couldn’t checkQuote
The PostgreSQL 18 commit says the old SQL function plans could not be customized to specific values of the function's parameters.
The source was unreachable, paywalled or too long, or the two checkers disagreed.
The article says “could not be customized to specific values of the function’s parameters”
The source says No passage could be compared.
Source cited by the article: postgr.es/c/0dca5d68d
Matches sourceQuote
The PostgreSQL documentation says function arguments and local variables can be inserted into queries as constants for planning purposes.
The cited source says the same thing.
The article says “the values of function arguments and local variables can be inserted into queries as constants for planning purposes”
The source says “since the values of function arguments and local variables can be inserted into queries as constants for planning purposes”
Source cited by the article: postgresql.org/docs/17/sql-expressions.html
Matches sourceQuote
The PostgreSQL PREPARE documentation says the first five executions are done with custom plans.
The cited source says the same thing.
The article says “the first five executions are done with custom plans”
The source says “The current rule for this is that the first five executions are done with custom plans and the average estimated cost of those plans is calculated”
Source cited by the article: postgresql.org/docs/17/sql-prepare.html
Matches sourceQuote
The PostgreSQL documentation says json checks Unicode escapes only for syntactic correctness, while jsonb rejects \u0000 because it cannot be represented in PostgreSQL's text type.
The cited source says the same thing.
The article says “rejects \u0000 (because that cannot be represented in PostgreSQL’s text type”
The source says “In the input function for the json type, Unicode escapes are allowed regardless of the database encoding, and are checked only for syntactic correctness”
Source cited by the article: postgresql.org/docs/17/datatype-json.html
Matches sourceQuote
The node-postgres documentation says JavaScript arrays are converted to a string describing a Postgres array, and objects get JSON.stringify.
The cited source says the same thing.
The article says “Converted to a string that describes a Postgres array”
The source says “Converted to a string that describes a Postgres array. Each array item is recursively converted using the rules described here”
Source cited by the article: node-postgres.com/features/queries
No source givenCausal conclusion
On PostgreSQL 18.6, an immutable SQL function wrapping the pg_input_is_valid guard failed on invalid values arriving in its first five calls in a session, while 16.15 and 17.11 did not fail.
The article gives no link or citation for it.
The article says “In a new session it failed when the invalid value came in one of the function’s first five calls, and from the sixth call on it returned NULL”
The source says No source to compare with.
No source givenGeneralization
IS JSON gave the same answers as pg_input_is_valid(txt, 'json') over all 38 inputs and differed from the jsonb check on three inputs, which a cast to jsonb rejected.
The article gives no link or citation for it.
The article says “IS JSON called them valid, and a cast to jsonb failed on all three”
The source says No source to compare with.
Also covered by
No other coverage was clustered with this story.
Elsewhere
Elsewhere: HN 4 pts, not on front page
Recorded for context only, checked 18 Nov 2026, 05:47 UTC. It played no part in the ranking.