Postgres Pro
Downloads
Home   >   mailing lists

ARRAY_LENGTH() function behavior with empty array - Mailing list pgsql-general

From otar shavadze
Subject ARRAY_LENGTH() function behavior with empty array
Date
Msg-id CAG-jOyAJAyebZj_K-qqTR+W4VjvH2mCePppWYi48qoggiaR-MQ@mail.gmail.com
Whole thread Raw
Responses Re: ARRAY_LENGTH() function behavior with empty array
List pgsql-general
Tree view
SELECT ARRAY_LENGTH('{}'::INT[], 1)

This returns NULL, not so "dangerous" either way,  not would be more logically, if  array length function will return 0 from empty array, instead of NULL ?

This is just IMHO.



pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Postgresql 9.6 and Big Data
Next
From: pinker
Date:
Subject: Strange activity of prepared queries