Postgres 14

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

select version();

version

PostgreSQL 14.23 (Debian 14.23-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

-- multirange types arrived in PostgreSQL 14: unlike a range, they can have gaps
select int4multirange(int4range(1,10)) - int4multirange(int4range(3,5)) as with_gap;

with_gap

{[1,3),[5,10)}

SELECT 1

-- jsonb subscripting also arrived in 14
select ('{"a":{"b":42}}'::jsonb)['a']['b'] as nested;

nested

42

SELECT 1