Commits

Andrew Dunstan committed ad2cee3

doc fixes

Comments (0)

Files changed (1)

doc/src/sgml/func.sgml

          </indexterm>
          <literal>json_each_as_text(from_json json)</literal>
        </entry>
-       <entry>SETOF key text, value text<entry>
+       <entry>SETOF key text, value text</entry>
        <entry>
          Expands the outermost json object into a set of key/value pairs. The
          returned value will be of type text.
       </row>           
       <row>
        <entry>
-         <indexterm>
-          <primary>json_get</primary>
-         </indexterm>
          <literal>json_get(json, key text)</literal>
        </entry>
        <entry>json</entry>       
       </row>   
       <row>
        <entry>
-         <indexterm>
-          <primary>json_get_as_text</primary>
-         </indexterm>
          <literal>json_get(json, key text)</literal>
        </entry>
        <entry>text</entry>       
          <indexterm>
           <primary>json_populate_record</primary>
          </indexterm>
-         <literal></literal>
+         <literal>json_populate_record(base anyelement, from_json json, [, use_json_as_text bool=false]</literal>
        </entry>
        <entry>anyelement</entry>
        <entry>
        </entry>
       </row>   
      </tbody>
-     </tbody>
     </tgroup>
    </table>
    <table id="functions-json-op-table">
         <entry><literal>-&gt;</literal></entry>
         <entry>int</entry>
         <entry>Get JSON array element</entry>
-        <entry><literal>'[1,2,3]'::json->2</literal></entry>
+        <entry><literal>'[1,2,3]'::json-&gt;2</literal></entry>
        </row>
        <row>
         <entry><literal>-&gt;</literal></entry>
         <entry>text</entry>
         <entry>Get JSON object field</entry>
-        <entry><literal>'{"a":1,"b":2}'::json->'b'</literal></entry>
+        <entry><literal>'{"a":1,"b":2}'::json-&gt;'b'</literal></entry>
        </row>
         <row>
-        <entry><literal>-&gt;</literal></entry>
+        <entry><literal>-&gt;&gt;</literal></entry>
         <entry>int</entry>
         <entry>Get JSON array element as text</entry>
-        <entry><literal>'[1,2,3]'::json->2</literal></entry>
+        <entry><literal>'[1,2,3]'::json-&gt;&gt;2</literal></entry>
        </row>
        <row>
-        <entry><literal>-&gt;</literal></entry>
+        <entry><literal>-&gt;&gt;</literal></entry>
         <entry>text</entry>
         <entry>Get JSON object field as text</entry>
-        <entry><literal>'{"a":1,"b":2}'::json->'b'</literal></entry>
+        <entry><literal>'{"a":1,"b":2}'::json-&gt;&gt;'b'</literal></entry>
+       </row>
+       <row>
+        <entry><literal>-&gt;</literal></entry>
+        <entry>array of text</entry>
+        <entry>Get JSON object at specified path</entry>
+        <entry><literal>'{"a":[1,2,3],"b":[4,5,6]}'::json-&gt;ARRAY['a','2']</literal></entry>
+       </row>
+       <row>
+        <entry><literal>-&gt;&gt;</literal></entry>
+        <entry>array of text</entry>
+        <entry>Get JSON object at specified path as text</entry>
+        <entry><literal>'{"a":[1,2,3],"b":[4,5,6]}'::json-&gt;&gt;ARRAY['a','2']</literal></entry>
        </row>
       </tbody>
      </tgroup>
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.