X-Received: by 10.129.55.13 with SMTP id e13mr3206664ywa.9.1473876633460; Wed, 14 Sep 2016 11:10:33 -0700 (PDT)
X-Received: by 10.157.15.139 with SMTP id d11mr317442otd.12.1473876633335; Wed, 14 Sep 2016 11:10:33 -0700 (PDT)
Path: csiph.com!feeder.erje.net!1.us.feeder.erje.net!news.linkpendium.com!news.linkpendium.com!news.snarked.org!border2.nntp.dca1.giganews.com!nntp.giganews.com!w41no133552qtw.1!news-out.google.com!b4ni821iti.0!nntp.google.com!x192no386968itb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.databases.postgresql
Date: Wed, 14 Sep 2016 11:10:30 -0700 (PDT)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=74.213.163.66; posting-account=wDbfzQoAAACmihbg4mfm8WpnlcsFE2Di
NNTP-Posting-Host: 74.213.163.66
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <0ea4dc3b-c59e-4dae-9fe5-42b8fb0ca55a@googlegroups.com>
Subject: hstore column update
From: leandro.bozo@gmail.com
Injection-Date: Wed, 14 Sep 2016 18:10:33 +0000
Content-Type: text/plain; charset=UTF-8
Lines: 8
Xref: csiph.com comp.databases.postgresql:720

I am trying to add a key-value pair to an existing HSTORE row:

UPDATE hstore_test SET sale = sale || '"cupcakes"=>"20"'::hstore;

It does not work on my local database, version is below:

"PostgreSQL 9.4.4 on x86_64-apple-darwin14.3.0, compiled by Apple LLVM version 6.1.0 (clang-602.0.53) (based on LLVM 3.6.0svn), 64-bit"

Please help me figure out what I am doing wrong.