The description reads as `Returns the length of the requested array dimension.`
For me, an expected result for an empty array would be `0`, but it is `NULL`. Tested on `PostgreSQL 13.4` with query `SELECT ARRAY_LENGTH(ARRAY[]::CHARACTER VARYING[],1);`
I believe, such case deserves to be mentioned in the description and/or in examples.