On 6/4/21 7:32 AM, Laura Smith wrote:
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 ?
tstzrange is over timestamp with time zone, so time zones are already taken into account.
Thanks ! Laura
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
