diff options
author | Andrew Dunstan <andrew@dunslane.net> | 2014-03-26 10:18:24 -0400 |
---|---|---|
committer | Andrew Dunstan <andrew@dunslane.net> | 2014-03-26 10:18:24 -0400 |
commit | f9c6d72cbf49257fea4265d994b96e66f25b2474 (patch) | |
tree | cb6117cc88855a54d382bbeae26303ee9a24af0b /doc/src | |
parent | 28475f8e58bd5da2b44a42203665a543f335c6a3 (diff) | |
download | postgresql-f9c6d72cbf49257fea4265d994b96e66f25b2474.tar.gz postgresql-f9c6d72cbf49257fea4265d994b96e66f25b2474.zip |
Cleanup around json_to_record/json_to_recordset
Set function parameter names and defaults. Add jsonb versions (which the
code already provided for so the actual new code is trivial). Add jsonb
regression tests and docs.
Bump catalog version (which I apparently forgot to do when jsonb was
committed).
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/func.sgml | 18 |
1 files changed, 12 insertions, 6 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 4e2fff7cd74..6e2fbda6c23 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -10444,8 +10444,14 @@ table2-mapping <primary>json_to_record</primary> </indexterm> <indexterm> + <primary>jsonb_to_record</primary> + </indexterm> + <indexterm> <primary>json_to_recordset</primary> </indexterm> + <indexterm> + <primary>jsonb_to_recordset</primary> + </indexterm> <table id="functions-json-processing-table"> <title>JSON Processing Functions</title> @@ -10649,9 +10655,9 @@ table2-mapping <entry><literal>number</literal></entry> </row> <row> - <entry> - <literal>json_to_record(json, nested_as_text bool)</literal> - </entry> + <entry><para><literal>json_to_record(json [, nested_as_text bool=false])</literal> + </para><para><literal>jsonb_to_record(jsonb [, nested_as_text bool=false])</literal> + </para></entry> <entry><type>record</type></entry> <entry> Returns an arbitrary record from a JSON object. As with all functions @@ -10670,9 +10676,9 @@ table2-mapping </entry> </row> <row> - <entry> - <literal>json_to_recordset(json, nested_as_text bool)</literal> - </entry> + <entry><para><literal>json_to_recordset(json [, nested_as_text bool=false])</literal> + </para><para><literal>jsonb_to_recordset(jsonb [, nested_as_text bool=false])</literal> + </para></entry> <entry><type>setof record</type></entry> <entry> Returns an arbitrary set of records from a JSON object. As with |