Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 16.14 (Debian 16.14-1.pgdg12+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit

SELECT 1

-- SQL/JSON constructors arrived in PostgreSQL 16
select json_array(1,'two',null) as arr;

arr

[1, "two"]

SELECT 1

-- pg_input_is_valid() also arrived in 16: test a cast without raising
select pg_input_is_valid('42','int') as ok
     , pg_input_is_valid('forty','int') as not_ok;

ok
not_ok

t
f

SELECT 1