The array functions in the IBM® Netezza® SQL Extensions toolkit rely on the array data type.
Because the Netezza database currently does not support user-defined types, the array type is stored in a varchar field. The maximum size of a varchar field is 64000 bytes.
The array type consists of a sequence of name-value pairs. Names can be a maximum of 40 characters in width. Values can be any built-in SQL type, but must be the same type for the entire array. Elements can be referenced by either name or by the 1-based index.