Postgres 17

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

select version();

version

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

-- JSON_TABLE arrived in PostgreSQL 17: a JSON document becomes rows
select *
from json_table(
  '[{"name":"ann","age":34},{"name":"bob","age":28}]'::jsonb,
  '$[*]' columns (name text path '$.name', age int path '$.age')
) as people;

name
age

ann
34

bob
28

SELECT 2

-- to_bin() and to_oct() also arrived in 17
select to_bin(42) as bin, to_oct(42) as oct, to_hex(42) as hex;

bin
oct
hex

101010
52
2a

SELECT 1