RE: BUG #14953: pg_blocking_pids / array_length inconsistency

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

Steven.

From: Marko Tiikkaja [mailto:marko(at)joh(dot)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(dot)winfield(at)cantabcapital(dot)com<mailto:steven(dot)winfield(at)cantabcapital(dot)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