EXCLUDE USING and tstzrange - Mailing list pgsql-general

From Laura Smith
Subject EXCLUDE USING and tstzrange
Date
Msg-id _I9_RfNXHYGvv2alXMBSyqodcq0ioZ0C-WpCQYRMZ6l6PEYon4DRt_x95siMaYMt1Gt4XkDe5TkgxIWm5shHc75mpyEA-V466SDX-3vCHuI=@protonmail.ch
Whole thread Raw
Responses Re: EXCLUDE USING and tstzrange  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Hi,

I'm having difficulty finding the right part of the docs for this one.

Could someone kindly clarify:

create table test (
test_id text,
test_range tstzrange);

Will "EXCLUDE USING gist (test_id WITH =, test_range WITH && )" work as expected or do I need to use "EXCLUDE USING
gist(test_id WITH =, test_range WITH TIME ZONE && )" to ensure the timezone is correctly taken into account during
comparison? 

Thanks !

Laura



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: BUG #17046: Upgrade postgres 11 to 13 version
Next
From: "Zwettler Markus (OIZ)"
Date:
Subject: autovacuum on pg_catalog tables