diff options
| author | Andrew Dunstan <andrew@dunslane.net> | 2014-01-31 09:31:58 -0500 |
|---|---|---|
| committer | Andrew Dunstan <andrew@dunslane.net> | 2014-01-31 09:31:58 -0500 |
| commit | e9afdf2f4bddb9d3a5a09aa8eff7fcc49db231d2 (patch) | |
| tree | 67739730377651fa00c99ef31c407fdaa6d6a4f9 /doc/src | |
| parent | cd3e0071b8c9e082f5fe903a019d4e474be98e57 (diff) | |
| download | postgresql-e9afdf2f4bddb9d3a5a09aa8eff7fcc49db231d2.tar.gz postgresql-e9afdf2f4bddb9d3a5a09aa8eff7fcc49db231d2.zip | |
Fix documented return type of json_array_elements_text.
Per gripe from hubert depesz lubaczewski.
Also improve examples for this and json_array_elements so they match the
example results.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 3802fbcbb0a..9c2708c09ba 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -10282,7 +10282,7 @@ table2-mapping <entry> Expands a JSON array to a set of JSON values. </entry> - <entry><literal>json_array_elements('[1,true, [2,false]]')</literal></entry> + <entry><literal>SELECT * FROM json_array_elements('[1,true, [2,false]]')</literal></entry> <entry> <programlisting> value @@ -10300,11 +10300,11 @@ table2-mapping </indexterm> <literal>json_array_elements_text(json)</literal> </entry> - <entry><type>SETOF json</type></entry> + <entry><type>SETOF text</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><literal>SELECT * FROM json_array_elements_text('["foo", "bar"]')</literal></entry> <entry> <programlisting> value |