Use the -1
索引连同insert_after = true
:
SELECT jsonb_insert( '{"res": [123, 456, 789, 101112]}', '{res, -1}', '333', true);
+-------------------------------------+
|jsonb_insert |
+-------------------------------------+
|{"res": [123, 456, 789, 101112, 333]}|
+-------------------------------------+
默认值为insert_after
is false
,这意味着虽然您的目标是最后一个元素 (index = -1),但您最终会插入到倒数第二个位置:
SELECT jsonb_insert( '{"res": [123, 456, 789, 101112]}', '{res, -1}', '333', false);
+-------------------------------------+
|jsonb_insert |
+-------------------------------------+
|{"res": [123, 456, 789, 333, 101112]}|
+-------------------------------------+