Sent with ProtonMail Secure Email.
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Friday, 4 June 2021 15:44, Adrian Klaver <adrian.kla...@aklaver.com> 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.kla...@aklaver.com
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 ?
