Postgres 19 beta 3

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

select version();

version

PostgreSQL 19beta3 (Debian 19~beta3-1.pgdg13+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit

SELECT 1

-- IGNORE NULLS in window functions is new in PostgreSQL 19
create table reading (t int, v int);
insert into reading values (1,10),(2,null),(3,null),(4,40),(5,null);

CREATE TABLE

INSERT 0 5

select t, v, last_value(v) ignore nulls over (order by t) as carried
from reading;

t
v
carried

1
10
10

2
null
10

3
null
10

4
40
40

5
null
40

SELECT 5

-- also new in 19: on conflict do select
create table tag (id int generated always as identity primary key, name text unique);
insert into tag (name) values ('red');

CREATE TABLE

INSERT 0 1

insert into tag (name) values ('red'),('blue')
on conflict (name) do select
returning id, name;

id
name

1
red

3
blue

INSERT 0 2

t	v	carried
1	10	10
2	null	10
3	null	10
4	40	40
5	null	40