Array functions

The array functions in the IBM® SQL Extensions toolkit rely on the array data type.

Because the Netezza Performance Server 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 64,000 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 they must be the same type for the entire array. Elements can be referenced either by name or by the 1-based index.