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
Michal Wronka
Sun Jun 4 10:07:48 2023
from
Wroclaw, Poland
via
Telnet
Michal Wronka
Sun Jun 4 09:59:22 2023
from
Wroclaw, Poland
via
Telnet
Michal Wronka
Sun Jun 4 09:54:09 2023
from
Wroclaw, Poland
via
Telnet
Michal Wronka
Sun Jun 4 09:44:48 2023
from
Wroclaw, Poland
via
Telnet
System Info
Sysop:
Keyop
Location:
Huddersfield, West Yorkshire, UK
Users:
185
Nodes:
16 (
1
/
15
)
Uptime:
20:28:47
Calls:
3,730
Calls today:
13
Files:
11,159
Messages:
3,452,888