{"action":"created","issue":{"url":"https://api.github.com/repos/tgriesser/knex/issues/2264","repository_url":"https://api.github.com/repos/tgriesser/knex","labels_url":"https://api.github.com/repos/tgriesser/knex/issues/2264/labels{/name}","comments_url":"https://api.github.com/repos/tgriesser/knex/issues/2264/comments","events_url":"https://api.github.com/repos/tgriesser/knex/issues/2264/events","html_url":"https://github.com/tgriesser/knex/issues/2264","id":264249889,"number":2264,"title":"how to update specific element in JSONB column","user":{"login":"zerosand1s","id":11810400,"avatar_url":"https://avatars3.githubusercontent.com/u/11810400?v=4","gravatar_id":"","url":"https://api.github.com/users/zerosand1s","html_url":"https://github.com/zerosand1s","followers_url":"https://api.github.com/users/zerosand1s/followers","following_url":"https://api.github.com/users/zerosand1s/following{/other_user}","gists_url":"https://api.github.com/users/zerosand1s/gists{/gist_id}","starred_url":"https://api.github.com/users/zerosand1s/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zerosand1s/subscriptions","organizations_url":"https://api.github.com/users/zerosand1s/orgs","repos_url":"https://api.github.com/users/zerosand1s/repos","events_url":"https://api.github.com/users/zerosand1s/events{/privacy}","received_events_url":"https://api.github.com/users/zerosand1s/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2017-10-10T14:28:29Z","updated_at":"2018-04-19T06:32:44Z","closed_at":"2017-10-10T16:35:41Z","author_association":"NONE","body":"hi, is there a way to update a specific element in PostgreSQL JSONB column? \r\nI have a jsonb column like {lat: value, lon: value}. I want to change either value at a time but I am not sure how I can do this. I tried using ```jsonb_set()``` method but could not achieve what I wanted."},"comment":{"url":"https://api.github.com/repos/tgriesser/knex/issues/comments/382625856","html_url":"https://github.com/tgriesser/knex/issues/2264#issuecomment-382625856","issue_url":"https://api.github.com/repos/tgriesser/knex/issues/2264","id":382625856,"user":{"login":"elhigu","id":696345,"avatar_url":"https://avatars3.githubusercontent.com/u/696345?v=4","gravatar_id":"","url":"https://api.github.com/users/elhigu","html_url":"https://github.com/elhigu","followers_url":"https://api.github.com/users/elhigu/followers","following_url":"https://api.github.com/users/elhigu/following{/other_user}","gists_url":"https://api.github.com/users/elhigu/gists{/gist_id}","starred_url":"https://api.github.com/users/elhigu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elhigu/subscriptions","organizations_url":"https://api.github.com/users/elhigu/orgs","repos_url":"https://api.github.com/users/elhigu/repos","events_url":"https://api.github.com/users/elhigu/events{/privacy}","received_events_url":"https://api.github.com/users/elhigu/received_events","type":"User","site_admin":false},"created_at":"2018-04-19T06:32:44Z","updated_at":"2018-04-19T06:32:44Z","author_association":"COLLABORATOR","body":"@markairwallex in my last comment is an example how to update single value. You need to use .raw and write postgresql specific SQL code for that update.\r\n\r\nLocking conversation to prevent answer from being lost in extra comments. If there are more problems related to this, open new issue or write a question to stackoverflow."}}
{"actor":{"display_login":"elhigu"}}