Database Reference
In-Depth Information
UPDATE list_demo SET list_col = list_col + [4,5] WHERE id =
1;
UPDATE list_demo SET list_col = [0] + list_col WHERE id = 1;
SELECT * FROM list_demo;
id | list_col
----+--------------------
1 | [0, 1, 3, 1, 4, 5]
(1 rows)
# Delete an item by the index
delete list_col[2] from list_demo WHERE id = 1;
SELECT * FROM list_demo;
id | list_col
----+-----------------
1 | [0, 1, 1, 4, 5]
(1 rows)
# Deleting an item in the list by value deletes all copies
of it
