Staticsยง
- _LINKME_
ELEMENT_ ๐jsonb_ set_ jsonb_ varchararray_ jsonb_ boolean_ jsonb - _LINKME_
ELEMENT_ ๐jsonb_ set_ jsonb_ varchararray_ jsonb_ jsonb
Functionsยง
- jsonb_
set3 ๐ - jsonb_
set4 ๐ - Returns
target
with the item designated bypath
replaced bynew_value
, or withnew_value
added ifcreate_if_missing
is true (which is the default) and the item designated by path does not exist. All earlier steps in the path must exist, or thetarget
is returned unchanged. As with the path oriented operators, negative integers that appear in the path count from the end of JSON arrays. - jsonb_
set_ ๐jsonb_ varchararray_ jsonb_ boolean_ jsonb - jsonb_
set_ ๐jsonb_ varchararray_ jsonb_ jsonb - jsonbb_
set_ ๐path - Recursively set
path[i..]
intarget
tonew_value
and write the result tobuilder
. - normalize_
array_ ๐index - Normalizes an array index to
0..len
. Negative indices count from the end. i.e.-len..0 => 0..len
. ReturnsNone
if index is out of bounds.