array_nulls

A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.

array_nulls

This controls whether the array input parser recognizes unquoted NULL as specifying a null array element. By default, this is on, allowing array values containing null values to be entered. Greenplum Database versions before 3.0 did not support null values in arrays, and therefore would treat NULL as specifying a normal array element with the string value 'NULL'.

Value Range Default Set Classifications
Boolean on master

session

reload