Groups > comp.databases.postgresql > #720

hstore column update

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> (permalink)
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

Show key headers only | View raw

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.

Back to comp.databases.postgresql | Previous | Next | Find similar

Thread

hstore column update leandro.bozo@gmail.com - 2016-09-14 11:10 -0700

csiph-web