EXCLUDE USING and tstzrange

From: Laura Smith <n5d9xq3ti233xiyif2vp(at)protonmail(dot)ch>
To: postgre <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: EXCLUDE USING and tstzrange
Date: 2021-06-04 14:32:53
Message-ID: _I9_RfNXHYGvv2alXMBSyqodcq0ioZ0C-WpCQYRMZ6l6PEYon4DRt_x95siMaYMt1Gt4XkDe5TkgxIWm5shHc75mpyEA-V466SDX-3vCHuI=@protonmail.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Zwettler Markus (OIZ) 2021-06-04 14:40:38 autovacuum on pg_catalog tables
Previous Message Adrian Klaver 2021-06-04 14:24:12 Re: BUG #17046: Upgrade postgres 11 to 13 version