May also be useful for processing elements. CROSS JOIN removes rows with missing or empty arrays. But we get double quoted strings from it.Īlternative query with aggregation in the outer query. SELECT ARRAY(SELECT jsonb_array_elements_text(t.data->'tags'))Įven shorter (and faster) with correlated subquery, returns empty array for empty array or null input: SELECT tbl_id, ARRAY(SELECT jsonb_array_elements_text(t.data->'tags')) AS txt_arrĪll of the above preserve original order of elements. Shorter (and faster) with ARRAY constructor, returns empty array for empty array or null input: SELECT t.tbl_id, t.data->'tags' AS jsonb_arr, d.txt_arr Short syntax, returns null for empty array or null input: SELECT t.tbl_id, d.txt_arrįROM jsonb_array_elements_text(t.data->'tags') - default name is "value"
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |