clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1451362 fiddles created (18695 in the last week).

CREATE TABLE test_hstore AS SELECT '1'::int AS id, NULL::hstore AS map; -- table with 1 row
1 rows affected
 hidden batch(es)


TABLE test_hstore;
id map
1
 hidden batch(es)


UPDATE test_hstore SET map = map || hstore('key1', 'value1') RETURNING *;
id map
1
 hidden batch(es)


UPDATE test_hstore SET map = COALESCE(map, '') || hstore('key1', 'value1') RETURNING *;
id map
1 "key1"=>"value1"
 hidden batch(es)