MIME-Version: 1.0
References: <CAAqOU0s08dTFu0tQgEg=q+ifeU4aSYwxCG=ae229PrwwAea2mA@mail.gmail.com>
In-Reply-To: <CAAqOU0s08dTFu0tQgEg=q+ifeU4aSYwxCG=ae229PrwwAea2mA@mail.gmail.com>
From: PetSerAl <petseral@gmail.com>
Date: Thu, 11 Jul 2024 18:02:03 +0300
Message-ID: <CAKygsHQFByAtLj7hq2D-e5vkm8gK=Yxsjx-LCXopA+Ovv7WOEg@mail.gmail.com>
Subject: Re: Postgresql range_agg() Return empty list
To: Han Tang <bj.tanghan@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAKygsHQFByAtLj7hq2D-e5vkm8gK%3DYxsjx-LCXopA%2BOvv7WOEg%40mail.gmail.com>
Precedence: bulk

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=E2=80=AFPM Han Tang <bj.tanghan@gmail.com> wro=
te:
>
> Hi
>
> Hope you are doing well!
>
> I am using range_agg() function, it works fine with original table value
>
> Query Result
>
> But when I try to do some update for range value, it will give back an em=
pty list
>
> Select range_agg(b.r)
> From (
>   Select int8range(lower(bin_range)+1, upper(bin_range)+5) as r
>   From bin_data) as b;
>
> Query Result
>
> I test with the same query in fiddle but no issue there
>
> https://dbfiddle.uk/1MRn8hn6
>
> All these query are running on pgAdmin4, wondering why it happens
>
> Thanks
> Han
>
>