MIME-Version: 1.0
References: <dwdB2YsSerbqrnxCL0GdRg7C61LmqBs4V-7-qC7t9sAq7_MY6Y76tQ4rhwHKbvJRr-6We87i_r0KHwDaf3yoxBbld1-62IPNoiZ3rtBGW8Q=@protonmail.ch>
In-Reply-To: <dwdB2YsSerbqrnxCL0GdRg7C61LmqBs4V-7-qC7t9sAq7_MY6Y76tQ4rhwHKbvJRr-6We87i_r0KHwDaf3yoxBbld1-62IPNoiZ3rtBGW8Q=@protonmail.ch>
From: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Date: Mon, 20 May 2024 15:48:53 +0500
Message-ID: <CAAPsdhfv3h0BQYkvwjXXsOssXmLNSGSDj=Huo7eiGAFBv30Jgw@mail.gmail.com>
Subject: Re: How to update upper-bound of tstzrange ?
To: Laura Smith <n5d9xq3ti233xiyif2vp@protonmail.ch>
Cc: postgre <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000000c7cba0618e0730c"
Archived-At: <https://www.postgresql.org/message-id/CAAPsdhfv3h0BQYkvwjXXsOssXmLNSGSDj%3DHuo7eiGAFBv30Jgw%40mail.gmail.com>
Precedence: bulk

--0000000000000c7cba0618e0730c
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi

Try this one.

UPDATE foo
SET bar_times =3D bar_times + INTERVAL '1 hour'
WHERE bar_id =3D 'abc';

Regards
Kashif Zeeshan
Bitnine Global

On Mon, May 20, 2024 at 3:30=E2=80=AFPM Laura Smith <
n5d9xq3ti233xiyif2vp@protonmail.ch> wrote:

> Could someone kindly help me out with the correct syntax ?
>
> My first thought was the below but that doesn't work:
>
> update foo set upper(bar_times)=3Dupper(bar_times)+interval '1' hour wher=
e
> bar_id=3D'abc';
> ERROR:  syntax error at or near "("
> LINE 1: update event_sessions set upper(bar_times)=3Dupper(bar_ti...
>
>
>

--0000000000000c7cba0618e0730c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi<div><br></div><div>Try this one.=C2=A0</div><div><br></=
div><div>UPDATE foo <br>SET bar_times =3D bar_times + INTERVAL &#39;1 hour&=
#39;<br>WHERE bar_id =3D &#39;abc&#39;;<br></div><div><br></div><div>Regard=
s</div><div>Kashif Zeeshan</div><div>Bitnine Global</div></div><br><div cla=
ss=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, May 20, 20=
24 at 3:30=E2=80=AFPM Laura Smith &lt;<a href=3D"mailto:n5d9xq3ti233xiyif2v=
p@protonmail.ch">n5d9xq3ti233xiyif2vp@protonmail.ch</a>&gt; wrote:<br></div=
><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border=
-left:1px solid rgb(204,204,204);padding-left:1ex">Could someone kindly hel=
p me out with the correct syntax ?<br>
<br>
My first thought was the below but that doesn&#39;t work:<br>
<br>
update foo set upper(bar_times)=3Dupper(bar_times)+interval &#39;1&#39; hou=
r where bar_id=3D&#39;abc&#39;;<br>
ERROR:=C2=A0 syntax error at or near &quot;(&quot;<br>
LINE 1: update event_sessions set upper(bar_times)=3Dupper(bar_ti...<br>
<br>
<br>
</blockquote></div>

--0000000000000c7cba0618e0730c--