added in version 2.1.1-beta, points that the update will silently ignore any warnings about trying to update a column which is not exists in current index schema.
strict
this option is used while updating JSON attributes; as of 2.2.1-beta, it's possible to update just some types in JSON. And if you try to update, for example, array type you'll get error with strict option on and warning otherwise.
Syntax is the same as
SELECT
clause.UPDATE
statement allows this options:ignore_nonexistent_columns
added in version 2.1.1-beta, points that the update will silently ignore any warnings about trying to update a column which is not exists in current index schema.
strict
this option is used while updating
JSON
attributes; as of 2.2.1-beta, it's possible to update just some types inJSON
. And if you try to update, for example, array type you'll get error withstrict
option on and warning otherwise.Reference here.