Re: BUG #14953: pg_blocking_pids / array_length inconsistency

Поиск
Список
Период
Сортировка
От Marko Tiikkaja
Тема Re: BUG #14953: pg_blocking_pids / array_length inconsistency
Дата
Msg-id CAL9smLAbczW=jsV41cYuaqdNCN8wg_LhyErV9ddO53k4i5M8AQ@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #14953: pg_blocking_pids / array_length inconsistency  (steven.winfield@cantabcapital.com)
Ответы RE: BUG #14953: pg_blocking_pids / array_length inconsistency  (Steven Winfield <Steven.Winfield@cantabcapital.com>)
Список pgsql-bugs
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: steven.winfield@cantabcapital.com
Дата:
Сообщение: BUG #14953: pg_blocking_pids / array_length inconsistency
Следующее
От: Steven Winfield
Дата:
Сообщение: RE: BUG #14953: pg_blocking_pids / array_length inconsistency