RE: BUG #14953: pg_blocking_pids / array_length inconsistency

Поиск
Список
Период
Сортировка
От Steven Winfield
Тема RE: BUG #14953: pg_blocking_pids / array_length inconsistency
Дата
Msg-id E9FA92C2921F31408041863B74EE4C2001A46B3347@CCPMAILDAG03.cantab.local
обсуждение исходный текст
Ответ на Re: BUG #14953: pg_blocking_pids / array_length inconsistency  (Marko Tiikkaja <marko@joh.to>)
Список pgsql-bugs
Дерево обсуждения

Thanks - I hadn’t spotted that, even though it was added in 9.4.

 

Steven.

 

From: Marko Tiikkaja [mailto:marko@joh.to]
Sent: 07 December 2017 15:07
To: Steven Winfield
Cc: Pg Bugs
Subject: Re: BUG #14953: pg_blocking_pids / array_length inconsistency

 

On Thu, Dec 7, 2017 at 3:40 PM, <steven.winfield@cantabcapital.com> wrote:

For what it's worth, I think having array_length('{}'::integer[], 1) = 0 is
far more sensible, and
making differently-dimensioned empty arrays compare equal (as mentioned
previously[1]) is quite confusing.

 

I'm not saying this isn't a bug, but you might want to start using the cardinality() function for comparisons like this.

 

 

.m

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Marko Tiikkaja
Дата:
Сообщение: Re: BUG #14953: pg_blocking_pids / array_length inconsistency
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #14953: pg_blocking_pids / array_length inconsistency