phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <>
Subject [jira] [Created] (PHOENIX-1710) Implement the json_extract_path_text built-in function
Date Sat, 07 Mar 2015 18:48:38 GMT
James Taylor created PHOENIX-1710:

             Summary: Implement the json_extract_path_text built-in function
                 Key: PHOENIX-1710
             Project: Phoenix
          Issue Type: Sub-task
            Reporter: James Taylor

Implement the json_extract_path_text modeled after the Postgres function. This function returns
JSON pointed to by the path elements argument. In Phoenix, it could be implemented like this:

VARCHAR json_extract_path_text (VARCHAR json, 
                                                         VARCHAR ARRAY path_elems paths)

For example:
SELECT json_extract_path_text(json_col, ARRAY['f4','f6'])
FROM my_table;

This message was sent by Atlassian JIRA

View raw message