Pop-Up Thingie
Sidebar
>>> Magnum BBS <<<
Home
Forum
Files
Dark
Log in
Username
Password
Sidebar
Forum
Usenet
COMP.DATABASES.POSTGRESQL
hstore column update
From
leandro.bozo@gmail.com
@21:1/5 to
All
on Wed Sep 14 11:10:30 2016
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.
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)
Who's Online
Recent Visitors
Keyop
Sun May 22 22:47:14 2022
from
Huddersfield, West Yorkshire
via
Telnet
Guest
Mon May 23 18:23:12 2022
from
It
via
Telnet
Keyop
Wed May 25 18:11:15 2022
from
Huddersfield, West Yorkshire
via
Telnet
Nemo
Wed May 25 03:25:40 2022
from
Maryland
via
SSH
System Info
Sysop:
Keyop
Location:
Huddersfield, West Yorkshire, UK
Users:
113
Nodes:
8 (
1
/
7
)
Uptime:
121:31:24
Calls:
2,501
Files:
8,692
Messages:
1,923,784