Using SELECT sub-query inside jsonb_array_elements_text function in Postgres

The syntax error seems to point somewhere else, so maybe I am wrong, but the problem I see is a missing pair of parentheses around the subquery:

jsonb_array_elements_text((SELECT ...))

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top