Postgres 12

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

select version();

version

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

SELECT 1

-- generated columns arrived in PostgreSQL 12
create table rect (w int, h int, area int generated always as (w * h) stored);
insert into rect (w,h) values (3,4),(5,6);

CREATE TABLE

INSERT 0 2

select * from rect;

w
h
area

3
4
12

5
6
30

SELECT 2

-- SQL/JSON path expressions also arrived in 12
select jsonb_path_query('{"items":[{"n":1},{"n":5}]}', '$.items[*].n ? (@ > 2)') as over_two;

over_two

5

SELECT 1