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:57:13 -0500 |
| commit | 24a26c9f5448b24943df4c9bcf154bfd9f8197a6 (patch) | |
| tree | f30a6a8174f5978ed1efbc29ecbbd4fdd789965e | |
| parent | 69d34408e5e7adcef8ef2f4e9c4f2919637e9a06 (diff) | |
| download | postgresql-24a26c9f5448b24943df4c9bcf154bfd9f8197a6.tar.gz postgresql-24a26c9f5448b24943df4c9bcf154bfd9f8197a6.zip | |
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 78cc8d53096..db5d4409a6e 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> |