Re: [GENERAL] array_length of an empty array

2012-07-29 Thread Tom Lane
John R Pierce writes: > hmmm.array[]::integer[]is an empty array, {}, eg an array with > zero elements > but array_length(array[]::integer[]) is NULL rather than zero.this > seems counterintuitive. IIRC, there are a whole bunch of questionable behaviors around empty arrays. Some

Re: [GENERAL] array_length of an empty array

2012-07-29 Thread Ryan Kelly
On Sun, Jul 29, 2012 at 01:03:04AM -0700, John R Pierce wrote: > hmmm.array[]::integer[]is an empty array, {}, eg an array > with zero elements > > but array_length(array[]::integer[]) is NULL rather than zero. > this seems counterintuitive. It also seems to disagree with the standard:

[GENERAL] array_length of an empty array

2012-07-29 Thread John R Pierce
hmmm.array[]::integer[]is an empty array, {}, eg an array with zero elements but array_length(array[]::integer[]) is NULL rather than zero.this seems counterintuitive. -- john r pierceN 37, W 122 santa cruz ca mid-left coast