[GENERAL] array_length of an empty array

[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 pierce                            N 37, W 122
santa cruz ca                         mid-left coast


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general