On Tue, Jun 21, 2022 at 09:02:41AM -0700, David G. Johnston wrote:
> On Tue, Jun 21, 2022 at 6:33 AM Aleksander Alekseev
> Maybe it's worth using `array_length(array[] :: int[], 1)` instead.
>
> I think subconsciously the cast looked ugly to me so I probably skipped adding
> it. I do agree t
On Tue, Jun 21, 2022 at 6:33 AM Aleksander Alekseev <
aleksan...@timescale.com> wrote:
> Hi David,
>
> > Per discussion here:
> >
> >
> https://www.postgresql.org/message-id/163636931138.8076.5140809232053731248%40wrigleys.postgresql.org
> >
> > We can now easily document the array_length behavior
Hi David,
> Per discussion here:
>
> https://www.postgresql.org/message-id/163636931138.8076.5140809232053731248%40wrigleys.postgresql.org
>
> We can now easily document the array_length behavior of returning null
> instead of zero for an empty array/dimension.
>
> I added an example to the json_
ray_length-produces-null-instead-of-0.patch
Description: Binary data