Answer the question
In order to leave comments, you need to log in
What is the best way to deal with json?
"{\"tags_in\":[102],\"tags_out\":[98]}"
Such json can only be parsed like this:
(campaign.search #>> '{}')::json->'tags_in' AS tags_in
- Ugly, inconvenient campaign.search::json->'tags_in' AS tags_in
- much better
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question