↑↓ 选择↵ 打开⌫ 切换范围完整搜索

PG.CENTER 连接 PostgreSQL 文档、百科与生态知识。由 Pigsty 维护。

Wiki / 配置参数

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. 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.

英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。

当前阅读 PG 18·选择有来源记录的版本

此版本暂无所选语言的定义,以下显示原始英文内容。

boot val
on
category
Version and Platform Compatibility / Previous PostgreSQL Versions
context
user
documented
true
enumvals
未知
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
未知
metadata version
18
min val
未知
name
array_nulls
short desc
Enables input of NULL elements in arrays.
source
pg-settings-source-snapshot
unit
未知
vartype
bool

版本定义 PG 18

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.

比较版本

来源引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · english-manuals:0aa053bdde4e3fa32388637453592876ea694ef3714875584027e81cac26a351

正文语言: en · english-manuals:0aa053bdde4e3fa32388637453592876ea694ef3714875584027e81cac26a351