Database Reference
In-Depth Information
(2 rows)
# Update a collection
UPDATE update_demo SET movies[2] = 'Amelie' WHERE id = 1;
SELECT * FROM update_demo;
id | movies | name
----+---------------------------------------+---------------
10 | ['Star Wars', 'Donnie darko'] | Movie Website
1 | ['Beautiful Mind', 'Se7en', 'Amelie'] | Movie Website
(2 rows)
# Lightweight transaction not applied as the condition did
not match
UPDATE update_demo SET name = 'Reviews' WHERE id = 1 IF
movies[2] = '1984';
[applied] | movies
-----------+---------------------------------------
False | ['Beautiful Mind', 'Se7en', 'Amelie']
