Postgres: convert text to array of JSONs by regular expression

text_to_json

CREATE OR REPLACE FUNCTION text_to_json(text text, regex varchar) RETURNS json[] AS $$ 
  DECLARE 
  chunk text; 
  res json[]; 
 BEGIN 
   FOREACH chunk IN array regexp_split_to_array(text, regex) 
   LOOP 
     IF TRIM(chunk) <> '' THEN 
       BEGIN 
         res := res || chunk::json; 
       EXCEPTION 
         WHEN invalid_text_representation THEN 
         RETURN ARRAY[to_json(text)]; 
       END; 
     END IF; 
   END LOOP; 
   RETURN res; 
 END; $$ 
 LANGUAGE 'plpgsql';