Postgres 15

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

select version();

version

PostgreSQL 15.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit

SELECT 1

select row(1,null::int) = (1,1::int);

?column?

null

SELECT 1

select record_eq(row(1,null::int),(1,1::int));

record_eq

f

SELECT 1

select record_eq(row(1,null),(1,1));

ERROR:  cannot compare dissimilar column types unknown and integer at record column 2

select record_eq(row(1,null::int),(1,1::int));

record_eq

f

SELECT 1

select record_eq(row(1,1::int),(1,1::int));
select (row(1,1::int) = (1,1::int));

record_eq

t

SELECT 1

?column?

t

SELECT 1