diff options
| author | Andrew Dunstan <andrew@dunslane.net> | 2014-01-29 15:39:01 -0500 |
|---|---|---|
| committer | Andrew Dunstan <andrew@dunslane.net> | 2014-01-29 15:39:01 -0500 |
| commit | 5264d9154178d3aeaa0359b43a450298a7ce7281 (patch) | |
| tree | f98aaa0c488b9e20e9e1621cbe74bc2e6f5f0aa1 /doc/src | |
| parent | 699b1f40da3139def660235fa8a782ec8dd8f575 (diff) | |
| download | postgresql-5264d9154178d3aeaa0359b43a450298a7ce7281.tar.gz postgresql-5264d9154178d3aeaa0359b43a450298a7ce7281.zip | |
Add json_array_elements_text function.
This was a notable omission from the json functions added in 9.3 and
there have been numerous complaints about its absence.
Laurence Rowe.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index cd886ab71a7..9816163354d 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -10286,6 +10286,27 @@ table2-mapping <row> <entry> <indexterm> + <primary>json_array_elements_text</primary> + </indexterm> + <literal>json_array_elements_text(json)</literal> + </entry> + <entry><type>SETOF json</type></entry> + <entry> + Expands a JSON array to a set of text values. + </entry> + <entry><literal>json_array_elements_text('["foo", "bar"]')</literal></entry> + <entry> +<programlisting> + value +----------- + foo + bar +</programlisting> + </entry> + </row> + <row> + <entry> + <indexterm> <primary>json_typeof</primary> </indexterm> <literal>json_typeof(json)</literal> |