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
Smithy
Fri Apr 19 18:53:54 2024
from
Plymouth
via
Telnet
Bob Worm
Fri Apr 19 14:04:19 2024
from
Wales, Uk
via
Telnet
Xyz
Sat Apr 20 12:48:50 2024
from
Earth
via
Telnet
Daniel Garrod
Sat Apr 20 11:50:15 2024
from
Cambridge, Uk
via
Telnet
System Info
Sysop:
Keyop
Location:
Huddersfield, West Yorkshire, UK
Users:
294
Nodes:
16 (
2
/
14
)
Uptime:
244:35:02
Calls:
6,626
Calls today:
2
Files:
12,175
Messages:
5,320,390