How to update upper-bound of tstzrange ?

From: Laura Smith <n5d9xq3ti233xiyif2vp(at)protonmail(dot)ch>
To: postgre <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: How to update upper-bound of tstzrange ?
Date: 2024-05-20 10:30:35
Message-ID: dwdB2YsSerbqrnxCL0GdRg7C61LmqBs4V-7-qC7t9sAq7_MY6Y76tQ4rhwHKbvJRr-6We87i_r0KHwDaf3yoxBbld1-62IPNoiZ3rtBGW8Q=@protonmail.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)=upper(bar_times)+interval '1' hour where bar_id='abc';
ERROR: syntax error at or near "("
LINE 1: update event_sessions set upper(bar_times)=upper(bar_ti...

Responses

Browse pgsql-general by date

  From Date Subject
Next Message milist ujang 2024-05-20 10:31:45 signal 11: Segmentation fault ; query constraint list; pg16.3
Previous Message Guillaume Lelarge 2024-05-20 09:33:45 Re: pg_dump and not MVCC-safe commands