postgres.git / summary / log / commit / refs

commit    e9afdf2f4bddb9d3a5a09aa8eff7fcc49db231d2
Author:   Andrew Dunstan <andrew@dunslane.net>
Date:     Fri Jan 31 14:31:58 2014 +0000
First released in: 9.4.0

    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.


 doc/src/sgml/func.sgml | 6 +++---
 1 file 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


[parent: cd3e0071b8c9]