Re: EXCLUDE USING and tstzrange

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