Changeset: 2530e6d63be1 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2530e6d63be1
Added Files:
documentation/source/json.rst
Modified Files:
documentation/source/index.rst
Branch: json
Log Message:
Start documentation for JSON
diffs (43 lines):
diff --git a/documentation/source/index.rst b/documentation/source/index.rst
--- a/documentation/source/index.rst
+++ b/documentation/source/index.rst
@@ -11,6 +11,7 @@ Welcome to MonetDB's documentation!
:caption: Contents:
input
+ json
clients
manual_pages
diff --git a/documentation/source/json.rst b/documentation/source/json.rst
new file mode 100644
--- /dev/null
+++ b/documentation/source/json.rst
@@ -0,0 +1,27 @@
+***************************
+Support for JSON in MonetDB
+***************************
+
+MonetDB supports columns having the JSON type.
+
+Usage
+=====
+
+The JSON type is implemented as a subtype of ``VARCHAR``, that is guarranteed
to
+only contain valid JSON strings. For example
+
+.. code:: sql
+
+ CREATE TABLE json_example (c1 JSON NOT NULL);
+ INSERT INTO json_example VALUES ('{"k1": 1, "k2": "foo", "k3": [1,2,3]}');
+
+MonetDB provides an implementation of `JSONpath`_ as the means to interact with
+JSON data.
+
+.. _JSONpath: https://goessner.net/articles/JsonPath/
+
+============================
=========================================================
+``json.filter(J, Pathexpr)`` Extracts the component from ``J`` that satisfied
the Pathexpr
+``json.filter(J, Number)`` Extracts an indexed component from ``J``
+``json.text()``
+============================
=========================================================
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
