Postgres 18

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

select version();

version

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

-- uuidv7() is new in PostgreSQL 18: time-ordered UUIDs
create table t (id uuid default uuidv7() primary key, name text);
insert into t (name) values ('alpha'),('beta'),('gamma');

CREATE TABLE

INSERT 0 3

select name, id, uuid_extract_timestamp(id) as created
from t
order by id;

name
id
created

alpha
01a00142-7f00-7587-907b-4d48dd457d96
2026-08-14 17:12:10.24+00

beta
01a00142-7f01-7258-b86a-dc88868bbd3c
2026-08-14 17:12:10.241+00

gamma
01a00142-7f01-72a3-9a9d-9d34ff0d7097
2026-08-14 17:12:10.241+00

SELECT 3

-- also new in 18
select array_sort(array[3,1,2]) as sorted
     , array_reverse(array[1,2,3]) as reversed
     , casefold('AbC') as folded;

sorted
reversed
folded

{1,2,3}
{3,2,1}
abc

SELECT 1

name	id	created
alpha	01a00142-7f00-7587-907b-4d48dd457d96	2026-08-14 17:12:10.24+00
beta	01a00142-7f01-7258-b86a-dc88868bbd3c	2026-08-14 17:12:10.241+00
gamma	01a00142-7f01-72a3-9a9d-9d34ff0d7097	2026-08-14 17:12:10.241+00