INSERT_RIGHT_REF_DEFAULT_VALUE

In B-compatible mode, the INSERT statement supports right-value reference. If a referenced column has a NOT NULL constraint and does not have a default value, its base value is used for calculation. If there is no basic value, the NULL value is used for calculation (array type or user-defined type). The basic values of the supported types are shown in Table 1.

Table 1 Type basic values

Type	Basic Value	Description
int	0
tinyint	0
smallint	0
integer	0
binary_integer	0
bigint	0
boolean	f
numeric	0
decimal	0
dec	0
double precision	0
float8	0
float	0
char(n)	""	Note: When a character string is involved in calculation, the value type is converted based on built-in rules. The length of the value stored by a fixed-length character string is the same as the specified length, and blank characters are filled (which may vary according to the storage mode).
varchar(n)	""
varchar2(n)	""
nchar(n)	""	Note: When a character string is involved in calculation, the value type is converted based on built-in rules. The length of the value stored by a fixed-length character string is the same as the specified length, and blank characters are filled (which may vary according to the storage mode).
nvarchar2(n)	""
nvarchar(n)	""
date	01-01-1970
time	00:00:00
timestamp	Current timestamp
smalldatetime	Thu Jan 01 00:00:00 1970
interval year	@ 0
interval month	@ 0
interval day	@ 0
interval hour	@ 0
interval minute	@ 0
interval second	@ 0
interval day to second	@ 0
interval day to hour	@ 0
interval day to minute	@ 0
interval hour to minute	@ 0
interval hour to second	@ 0
interval minute to second	@ 0
reltime	@ 0
abstime	Wed Dec 31 16:00:00 1969 PST
money	$0.00
int4range	empty
blob		Object without data content
raw		Object without data content
bytea	\x
point	(0,0)
lseg	[(0,0),(0,0)]
box	(0,0),(0,0)
path	((0,0))
polygon	((0,0))
circle	<(0,0),0>
cidr	0.0.0.0/32
inet	0.0.0.0
macaddr	00:00:00:00:00:00
BIT		Object without data content
BIT VARYING		Object without data content
UUID	00000000-0000-0000-0000-000000000000
json	null	The data content is null.
jsonb	null	The data content is null.
int8range	empty
numrange	empty
tsrange	empty
tstzrange	empty
daterange	empty
hll	\x
SET	""
tsvector		Object without data content
tsquery		Object without data content
HASH16	0000000000000000
HASH32	00000000000000000000000000000000
enum	The first item