Re: help to query json column

2018-03-07 Thread Arup Rakshit
ists.postgresql.org >> Subject: help to query json column >> >> Hi, >> >> I would like to select only rows where signature has a non null value. My >> json looks like : >> >> { >> "carInspection": { >&g

RE: help to query json column

2018-03-06 Thread Charles Clavadetscher
Hello > -Original Message- > From: Arup Rakshit [mailto:aruprakshit1...@outlook.com] > Sent: Mittwoch, 7. März 2018 05:41 > To: pgsql-general@lists.postgresql.org > Subject: help to query json column > > Hi, > > I would like to select only rows where signatu

help to query json column

2018-03-06 Thread Arup Rakshit
Hi, I would like to select only rows where signature has a non null value. My json looks like : { "carInspection": { "damages": [ { "x": 68.670309653916, "y": 44.08014571949, "errors": [ { "code": "BR", "description": "Gebroch