Database Reference
In-Depth Information
1 | {'head', 'tail'}
(1 rows)
# You can append, but cannot prepend, but order is not
preserved. So, it does not matter.
UPDATE set_demo SET set_col = set_col + { 'right' } WHERE
id = 1;
SELECT * FROM set_demo;
id | set_col
----+---------------------------
1 | {'head', 'right', 'tail'}
(1 rows)
# Removing an element is similar to adding one
UPDATE set_demo SET set_col = set_col - { 'head' } WHERE
id = 1;
SELECT * FROM set_demo;
id | set_col
----+-------------------
1 | {'right', 'tail'}
Search WWH ::




Custom Search