S
S
Steve2021-06-14 10:12:00
PostgreSQL
Steve, 2021-06-14 10:12:00

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

What to do, why the data is automatically screened?

* 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 question

Ask a Question

731 491 924 answers to any question