diff options
| author | Andrew Dunstan <andrew@dunslane.net> | 2012-02-03 12:11:16 -0500 |
|---|---|---|
| committer | Andrew Dunstan <andrew@dunslane.net> | 2012-02-03 12:11:16 -0500 |
| commit | 39909d1d39ae57c3a655fc7010e394e26b90fec9 (patch) | |
| tree | 7eff6f5605be63418574a53b085ed1fd420cd223 /doc/src | |
| parent | 69e9768e7b183d4b276d0e067a5a0000689580eb (diff) | |
| download | postgresql-39909d1d39ae57c3a655fc7010e394e26b90fec9.tar.gz postgresql-39909d1d39ae57c3a655fc7010e394e26b90fec9.zip | |
Add array_to_json and row_to_json functions.
Also move the escape_json function from explain.c to json.c where it
seems to belong.
Andrew Dunstan, Reviewd by Abhijit Menon-Sen.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 59 |
1 files changed, 59 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index ec140040843..22adcb8c5a0 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -9617,6 +9617,65 @@ table2-mapping </sect2> </sect1> + <sect1 id="functions-json"> + <title>JSON functions</title> + + <indexterm zone="datatype-json"> + <primary>JSON</primary> + <secondary>Functions and operators</secondary> + </indexterm> + + <para> + This section descripbes the functions that are available for creating + JSON (see <xref linkend="datatype-json">) data. + </para> + + <table id="functions-json-table"> + <title>JSON Support Functions</title> + <tgroup cols="4"> + <thead> + <row> + <entry>Function</entry> + <entry>Description</entry> + <entry>Example</entry> + <entry>Example Result</entry> + </row> + </thead> + <tbody> + <row> + <entry> + <indexterm> + <primary>array_to_json</primary> + </indexterm> + <literal>array_to_json(anyarray [, pretty_bool])</literal> + </entry> + <entry> + Returns the array as JSON. A Postgres multi-dimensional array + becomes a JSON array of arrays. Line feeds will be added between + dimension 1 elements if pretty_bool is true. + </entry> + <entry><literal>array_to_json('{{1,5},{99,100}}'::int[])</literal></entry> + <entry><literal>[[1,5],[99,100]]</literal></entry> + </row> + <row> + <entry> + <indexterm> + <primary>row_to_json</primary> + </indexterm> + <literal>row_to_json(record [, pretty_bool])</literal> + </entry> + <entry> + Returns the row as JSON. Line feeds will be added between level + 1 elements if pretty_bool is true. + </entry> + <entry><literal>row_to_json(row(1,'foo'))</literal></entry> + <entry><literal>{"f1":1,"f2":"foo"}</literal></entry> + </row> + </tbody> + </tgroup> + </table> + + </sect1> <sect1 id="functions-sequence"> <title>Sequence Manipulation Functions</title> |