diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2016-02-03 12:56:40 -0500 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2016-02-03 12:56:40 -0500 |
commit | c27fda69c919d3fcde5f4dfef11747f1584ed123 (patch) | |
tree | 8558a1b7f0b446a6f913c3041eba535071d2ae93 | |
parent | c33d1a8d5266d345bf777b1a9256cb7155d7e67f (diff) | |
download | postgresql-c27fda69c919d3fcde5f4dfef11747f1584ed123.tar.gz |
Add hstore_to_jsonb() and hstore_to_jsonb_loose() to hstore documentation.
These were never documented anywhere user-visible. Tut tut.
-rw-r--r-- | doc/src/sgml/hstore.sgml | 26 |
1 files changed, 23 insertions, 3 deletions
diff --git a/doc/src/sgml/hstore.sgml b/doc/src/sgml/hstore.sgml index fbe9543dfe..9618eb8e97 100644 --- a/doc/src/sgml/hstore.sgml +++ b/doc/src/sgml/hstore.sgml @@ -325,12 +325,22 @@ b <row> <entry><function>hstore_to_json(hstore)</function><indexterm><primary>hstore_to_json</primary></indexterm></entry> <entry><type>json</type></entry> - <entry>get <type>hstore</type> as a <type>json</type> value</entry> + <entry>get <type>hstore</type> as a <type>json</type> value, converting + all non-null values to JSON strings</entry> <entry><literal>hstore_to_json('"a key"=>1, b=>t, c=>null, d=>12345, e=>012345, f=>1.234, g=>2.345e+4')</literal></entry> <entry><literal>{"a key": "1", "b": "t", "c": null, "d": "12345", "e": "012345", "f": "1.234", "g": "2.345e+4"}</literal></entry> </row> <row> + <entry><function>hstore_to_jsonb(hstore)</function><indexterm><primary>hstore_to_jsonb</primary></indexterm></entry> + <entry><type>jsonb</type></entry> + <entry>get <type>hstore</type> as a <type>jsonb</type> value, converting + all non-null values to JSON strings</entry> + <entry><literal>hstore_to_jsonb('"a key"=>1, b=>t, c=>null, d=>12345, e=>012345, f=>1.234, g=>2.345e+4')</literal></entry> + <entry><literal>{"a key": "1", "b": "t", "c": null, "d": "12345", "e": "012345", "f": "1.234", "g": "2.345e+4"}</literal></entry> + </row> + + <row> <entry><function>hstore_to_json_loose(hstore)</function><indexterm><primary>hstore_to_json_loose</primary></indexterm></entry> <entry><type>json</type></entry> <entry>get <type>hstore</type> as a <type>json</type> value, but attempt to distinguish numerical and Boolean values so they are unquoted in the JSON</entry> @@ -339,6 +349,14 @@ b </row> <row> + <entry><function>hstore_to_jsonb_loose(hstore)</function><indexterm><primary>hstore_to_jsonb_loose</primary></indexterm></entry> + <entry><type>jsonb</type></entry> + <entry>get <type>hstore</type> as a <type>jsonb</type> value, but attempt to distinguish numerical and Boolean values so they are unquoted in the JSON</entry> + <entry><literal>hstore_to_jsonb_loose('"a key"=>1, b=>t, c=>null, d=>12345, e=>012345, f=>1.234, g=>2.345e+4')</literal></entry> + <entry><literal>{"a key": 1, "b": true, "c": null, "d": 12345, "e": "012345", "f": 1.234, "g": 2.345e+4}</literal></entry> + </row> + + <row> <entry><function>slice(hstore, text[])</function><indexterm><primary>slice</primary></indexterm></entry> <entry><type>hstore</type></entry> <entry>extract a subset of an <type>hstore</></entry> @@ -414,8 +432,10 @@ b <note> <para> - The function <function>hstore_to_json</function> is used when an <type>hstore</type> - value is cast to <type>json</type>. + The function <function>hstore_to_json</function> is used when + an <type>hstore</type> value is cast to <type>json</type>. + Likewise, <function>hstore_to_jsonb</function> is used when + an <type>hstore</type> value is cast to <type>jsonb</type>. </para> </note> |