We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see ourdocumentation.
There was an error while loading.Please reload this page.
1 parentcd3e007 commite9afdf2Copy full SHA for e9afdf2
doc/src/sgml/func.sgml
@@ -10282,7 +10282,7 @@ table2-mapping
10282
<entry>
10283
Expands a JSON array to a set of JSON values.
10284
</entry>
10285
- <entry><literal>json_array_elements('[1,true, [2,false]]')</literal></entry>
+ <entry><literal>SELECT * FROMjson_array_elements('[1,true, [2,false]]')</literal></entry>
10286
10287
<programlisting>
10288
value
@@ -10300,11 +10300,11 @@ table2-mapping
10300
</indexterm>
10301
<literal>json_array_elements_text(json)</literal>
10302
10303
- <entry><type>SETOFjson</type></entry>
+ <entry><type>SETOFtext</type></entry>
10304
10305
Expands a JSON array to a set of text values.
10306
10307
- <entry><literal>json_array_elements_text('["foo", "bar"]')</literal></entry>
+ <entry><literal>SELECT * FROMjson_array_elements_text('["foo", "bar"]')</literal></entry>
10308
10309
10310