Answer the question
In order to leave comments, you need to log in
Convert json array to array in request?
Good afternoon!
There is a column in the table (column1) containing uuid identifiers in json format ["9ff57f69-262a-4eee-874f-6149e42b5e12","12fffa49-524d-4ddc-91f0-5c489591748e"]
How to make this array of json identifiers in a subquery uuid to convert to array?
That is, to get:
WHERE id IN ('9ff57f69-262a-4eee-874f-6149e42b5e12','12fffa49-524d-4ddc-91f0-5c489591748e')
WHERE id IN (column1)
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