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(dot)klaver(at)aklaver(dot)com