Re: doc: array_length produces null instead of 0

2022-07-08 Thread Bruce Momjian
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

Re: doc: array_length produces null instead of 0

2022-06-21 Thread David G. Johnston
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

Re: doc: array_length produces null instead of 0

2022-06-21 Thread Aleksander Alekseev
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

doc: array_length produces null instead of 0

2022-06-09 Thread David G. Johnston
ray_length-produces-null-instead-of-0.patch Description: Binary data