Your update expression does not handle empty ranges properly, but
convert them into complete ranges.
https://dbfiddle.uk/Ia6wESpL
On Thu, Jul 11, 2024 at 5:55 PM Han Tang wrote:
>
> Hi
>
> Hope you are doing well!
>
> I am using range_agg() function, it works fine with original table value
>
>
On Wed, Jul 10, 2024 at 6:37 PM Han Tang wrote:
> I am using range_agg() function, it works fine with original table value
>
> But when I try to do some update for range value, it will give back an empty
> list
>
> Select range_agg(b.r)
> From (
> Select int8range(lower(bin_range)+1,