Postgresql allows to have flexible arrays with unspecified length in your definition and there are also some array-specific functions to work with them but oddly enough, there is no simple function to get the array length. In some older versions of postgresql there was a function named "array_length(array, int)" but in my version I get an error about this function being unknown (postgresql 8.4.2). In the documentation this function appears and disappears, depending on where you are looking at.

Read on to find out how to get the length of an array.

more...