Database Reference
In-Depth Information
<int>);
# Insert some values with duplicates in the list
INSERT INTO list_demo (id, list_col ) VALUES ( 1, [1, 2,
1]);
select * from list_demo;
id | list_col
----+-----------
1 | [1, 2, 1]
(1 rows)
# Updating value in at index 1
UPDATE list_demo set list_col[1] = 3 WHERE id = 1;
select * from list_demo;
id | list_col
----+-----------
1 | [1, 3, 1]
(1 rows)
# Appending and prepending a column
