Wiki / Configuration Parameters

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. However, PostgreSQL versions before 8.2 did not support null values in arrays, and therefore would treat NULL as specifying a normal array element with the string value “NULL”. For backward compatibility with applications that require the old behavior, this variable can be turned off. Note that it is possible to create array values containing null values even when this variable is off.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

boot val

on

category

Version and Platform Compatibility / Previous PostgreSQL Versions

context

user

documented

true

enumvals

Unknown

extra desc

When turned on, unquoted NULL in an array input value means a null value; otherwise it is taken literally.

lang

en

max val

Unknown

metadata version

18

min val

Unknown

name

array_nulls

short desc

Enables input of NULL elements in arrays.

source

pg-settings-source-snapshot

unit

Unknown

vartype

bool