Insert or delete only one value from json array in table.
So I have my table with json column with example values like this:
Now I'm doing it by selecting current array's state and updating it with inserted or deleted number but I want to do it with one request. I looked up in docs for
[1,2,9]. Now I want to insert values into this array without downloading current array's state. Now I'm doing it by selecting current array's state and updating it with inserted or deleted number but I want to do it with one request. I looked up in docs for
upsert() method but I don't think so it'll work that way. Any ideas?