YugabyteDB 2025.2 LTS

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

select version();

version

PostgreSQL 15.12-YB-2025.2.5.2-b0 on x86_64-pc-linux-gnu, compiled by clang version 19.1.0 (https://github.com/yugabyte/llvm-project.git a2a6b655e14e7fa1fcf1011a6cb29cb8575249c0), 64-bit

SELECT 1

-- 2025.2 moved YSQL onto a PostgreSQL 15 base, so several PostgreSQL
-- versions' features arrive at once. Generated columns (PG12):
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 order by w;

w
h
area

3
4
12

5
6
30

SELECT 2

-- multiranges (PG14) and FETCH ... WITH TIES (PG13)
select int4multirange(int4range(1,10)) - int4multirange(int4range(3,5)) as with_gap;

with_gap

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

SELECT 1