Groups > comp.databases.postgresql > #720

hstore column update

Newsgroups	comp.databases.postgresql
Date	2016-09-14 11:10 -0700
Message-ID	<0ea4dc3b-c59e-4dae-9fe5-42b8fb0ca55a@googlegroups.com> (permalink)
Subject	hstore column update
From	leandro.bozo@gmail.com

Show all headers | 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