-- set up variables for testing
\set uuidv7 '018570bb-4a7d-7000-8000-000000000000'
\set uuidtz '2023-01-02 04:26:40.637+00'
-- test converting a timestamp to a uuid
SELECT uuid_timestamptz_to_v7(:'uuidtz') > :'uuidv7';
 ?column? 
----------
 t
(1 row)

-- test converting a timestamp to a uuid and zero out the random bits
SELECT uuid_timestamptz_to_v7(:'uuidtz', true) = :'uuidv7';
 ?column? 
----------
 t
(1 row)