Sent with ProtonMail Secure Email. ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Friday, 4 June 2021 15:44, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote: > 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 Thank you Adrian ! One other question, what's the syntax for manipulating only the upper bound of a range. Say I have a Postgres function that does a "SELECT INTO" for an existing tsrange. Is there an easy way to change the variable's upper bound whilst leaving the "old" lower bound intact ?
