迈克尔·帕基尔：Postgres 16亮点 - JSON谓词
原文英文，约900词，阅读约需4分钟。发表于：。PostgreSQL 16 includes a set of features related to JSON to make the engine more compliant with the SQL standard. One of these features has been introduced by the following commit: commit:...
PostgreSQL 16新增JSON相关功能，支持IS JSON谓词，操作文本、bytea值、json和jsonb类型，测试包括IS JSON [VALUE]、IS JSON ARRAY、IS JSON OBJECT和IS JSON SCALAR，可选关键字VALUE用于检查值是否可以解析为JSON，WITH UNIQUE KEYS标志可避免重复键。
