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.kla...@aklaver.com
