Groups > comp.databases.postgresql > #812

Re: Update Json column

X-Received	by 10.200.69.19 with SMTP id q19mr10355737qtn.45.1520243093353; Mon, 05 Mar 2018 01:44:53 -0800 (PST)
X-Received	by 10.31.16.33 with SMTP id g33mr1588971vki.13.1520243093134; Mon, 05 Mar 2018 01:44:53 -0800 (PST)
Path	csiph.com!3.us.feeder.erje.net!feeder.erje.net!news.snarked.org!border2.nntp.dca1.giganews.com!nntp.giganews.com!t24no3747685qtn.0!news-out.google.com!a13ni645qtd.1!nntp.google.com!r16no3722490qtn.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.postgresql
Date	Mon, 5 Mar 2018 01:44:52 -0800 (PST)
In-Reply-To	<p78k0s$ani$1@dont-email.me>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=5.238.220.53; posting-account=AVfdWQoAAAB6NsIEvw9Dr_Zj2mt265Gj
NNTP-Posting-Host	5.238.220.53
References	<fd35c1ca-2d97-476e-88bd-36c0dd722b41@googlegroups.com> <p73l09$27o$1@dont-email.me> <c9fb27ea-edc5-44db-8bb4-92b262192d47@googlegroups.com> <p78k0s$ani$1@dont-email.me>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<23a909c9-9a4e-462a-89fa-a1efda4fb198@googlegroups.com> (permalink)
Subject	Re: Update Json column
From	forough m <fmirkarimzade@gmail.com>
Injection-Date	Mon, 05 Mar 2018 09:44:53 +0000
Content-Type	text/plain; charset="UTF-8"
Lines	17
Xref	csiph.com comp.databases.postgresql:812

Show key headers only | View raw

On Thursday, March 1, 2018 at 1:48:05 PM UTC+3:30, Laurenz Albe wrote:
> forough m wrote:
> 
> >>> I create a table with a Json type column. I need to update one
> >>> key:value in Json. i.e increment value of 3 to 5. Can i do it?
> >> 
> >> If you have PostgreSQL 9.5 or better, you can use "json_set" like this:
> >>
> >> [...]
> >>
> > Sorry. I test it but it has no result. SQL query executed without any
> > error but value in Json not changed.
> 
> Then you must be doing something wrong.
> Hard to say what if you don't show your query.

Worked. Thanks :) But, why it remove all fields if {b,c} not exist?
I want to insert it if not exist

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Update Json column forough m <fmirkarimzade@gmail.com> - 2018-02-26 22:09 -0800
  Re: Update Json column Laurenz Albe <laurenz@nospam.pn> - 2018-02-27 13:04 +0000
    Re: Update Json column forough m <fmirkarimzade@gmail.com> - 2018-02-28 03:06 -0800
    Re: Update Json column forough m <fmirkarimzade@gmail.com> - 2018-02-28 03:21 -0800
      Re: Update Json column Laurenz Albe <laurenz@nospam.pn> - 2018-03-01 10:18 +0000
        Re: Update Json column forough m <fmirkarimzade@gmail.com> - 2018-03-05 01:44 -0800
          Re: Update Json column forough m <fmirkarimzade@gmail.com> - 2018-03-06 07:47 -0800
            Re: Update Json column Laurenz Albe <laurenz@nospam.pn> - 2018-03-07 07:48 +0000
              Re: Update Json column forough m <fmirkarimzade@gmail.com> - 2018-03-07 00:09 -0800
                Re: Update Json column Laurenz Albe <laurenz@nospam.pn> - 2018-03-08 11:36 +0000
                Re: Update Json column forough m <fmirkarimzade@gmail.com> - 2018-03-09 21:07 -0800
              Re: Update Json column forough m <fmirkarimzade@gmail.com> - 2018-03-07 00:10 -0800

csiph-web