Postgres 16

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

create type trange as range(subtype=time);--automatically creates `tmultirange` variant
create type ttzrange as range(subtype=timetz);--automatically creates `tmultirange` variant

CREATE TYPE

CREATE TYPE

create table test (tmr ttzmultirange);

CREATE TABLE

insert into test 
select ttzmultirange(ttzrange('22:00','24:00'),ttzrange('00:00','05:00')) as tmr
returning *;

tmr

{[00:00:00+00,05:00:00+00),[22:00:00+00,24:00:00+00)}

INSERT 0 1

select tmr @> '01:00'::timetz as "is 1 o'clock in range" from test;

is 1 o'clock in range

t

SELECT 1