1. Forum
  2. Usenet
  3. 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)