You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@age.apache.org by gi...@apache.org on 2022/01/17 16:43:28 UTC
[incubator-age-website] branch asf-site updated: deploy: 1315697d604386833fe60950362d124cd566e568
This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/incubator-age-website.git
The following commit(s) were added to refs/heads/asf-site by this push:
new cf3fc16 deploy: 1315697d604386833fe60950362d124cd566e568
cf3fc16 is described below
commit cf3fc161897543af20da89fd7d55fae3a675edce
Author: JoshInnis <Jo...@users.noreply.github.com>
AuthorDate: Mon Jan 17 16:43:22 2022 +0000
deploy: 1315697d604386833fe60950362d124cd566e568
---
docs/master/.buildinfo | 2 +-
docs/master/.doctrees/advanced/advanced.doctree | Bin 17332 -> 17332 bytes
.../.doctrees/advanced/advanced_overview.doctree | Bin 3665 -> 3665 bytes
docs/master/.doctrees/advanced/plpgsql.doctree | Bin 4203 -> 4203 bytes
.../.doctrees/advanced/prepared_statements.doctree | Bin 8572 -> 8572 bytes
.../.doctrees/advanced/sql_in_cypher.doctree | Bin 5905 -> 5905 bytes
docs/master/.doctrees/clauses/create.doctree | Bin 20453 -> 20453 bytes
docs/master/.doctrees/clauses/delete.doctree | Bin 11208 -> 11208 bytes
docs/master/.doctrees/clauses/limit.doctree | Bin 7427 -> 7427 bytes
docs/master/.doctrees/clauses/match.doctree | Bin 25090 -> 28036 bytes
docs/master/.doctrees/clauses/order_by.doctree | Bin 15347 -> 15347 bytes
docs/master/.doctrees/clauses/remove.doctree | Bin 6630 -> 6630 bytes
docs/master/.doctrees/clauses/return.doctree | Bin 21591 -> 21591 bytes
docs/master/.doctrees/clauses/set.doctree | Bin 11952 -> 11952 bytes
docs/master/.doctrees/clauses/skip.doctree | Bin 9537 -> 9537 bytes
docs/master/.doctrees/clauses/with.doctree | Bin 11085 -> 11085 bytes
docs/master/.doctrees/environment.pickle | Bin 136659 -> 138038 bytes
.../functions/aggregate_functions.doctree | Bin 57674 -> 57674 bytes
.../.doctrees/functions/list_functions.doctree | Bin 18988 -> 18988 bytes
.../functions/logarithmic_functions.doctree | Bin 16326 -> 16326 bytes
.../.doctrees/functions/numeric_functions.doctree | Bin 22628 -> 22628 bytes
.../functions/predicate_functions.doctree | Bin 6445 -> 7764 bytes
.../.doctrees/functions/scalar_functions.doctree | Bin 56296 -> 56296 bytes
.../.doctrees/functions/string_functions.doctree | Bin 47885 -> 47885 bytes
.../functions/trigonometric_functions.doctree | Bin 34567 -> 34567 bytes
.../.doctrees/functions/user_functions.doctree | Bin 4976 -> 4976 bytes
docs/master/.doctrees/index.doctree | Bin 4122 -> 4122 bytes
docs/master/.doctrees/intro/aggregation.doctree | Bin 27322 -> 27322 bytes
docs/master/.doctrees/intro/comparability.doctree | Bin 32523 -> 32523 bytes
docs/master/.doctrees/intro/cypher.doctree | Bin 10246 -> 10246 bytes
docs/master/.doctrees/intro/graphs.doctree | Bin 11554 -> 11554 bytes
docs/master/.doctrees/intro/operators.doctree | Bin 22257 -> 22257 bytes
docs/master/.doctrees/intro/overview.doctree | Bin 4006 -> 4006 bytes
docs/master/.doctrees/intro/precedence.doctree | Bin 7042 -> 7042 bytes
docs/master/.doctrees/intro/setup.doctree | Bin 11024 -> 14235 bytes
docs/master/.doctrees/intro/types.doctree | Bin 81184 -> 81184 bytes
docs/master/_sources/clauses/match.md.txt | 37 +++++++++++++++++++++
.../_sources/functions/predicate_functions.md.txt | 34 ++++++++++++++++++-
docs/master/_sources/intro/setup.md.txt | 14 ++++++++
docs/master/clauses/match.html | 36 ++++++++++++++++++++
docs/master/functions/predicate_functions.html | 34 +++++++++++++++++--
docs/master/intro/setup.html | 16 +++++++++
docs/master/searchindex.js | 2 +-
docs/v0.6.0/.buildinfo | 2 +-
docs/v0.6.0/.doctrees/advanced/advanced.doctree | Bin 17332 -> 17332 bytes
.../.doctrees/advanced/advanced_overview.doctree | Bin 3665 -> 3665 bytes
docs/v0.6.0/.doctrees/advanced/plpgsql.doctree | Bin 4203 -> 4203 bytes
.../.doctrees/advanced/prepared_statements.doctree | Bin 8572 -> 8572 bytes
.../.doctrees/advanced/sql_in_cypher.doctree | Bin 5905 -> 5905 bytes
docs/v0.6.0/.doctrees/clauses/create.doctree | Bin 20453 -> 20453 bytes
docs/v0.6.0/.doctrees/clauses/delete.doctree | Bin 11208 -> 11208 bytes
docs/v0.6.0/.doctrees/clauses/limit.doctree | Bin 7427 -> 7427 bytes
docs/v0.6.0/.doctrees/clauses/match.doctree | Bin 25090 -> 25090 bytes
docs/v0.6.0/.doctrees/clauses/order_by.doctree | Bin 15347 -> 15347 bytes
docs/v0.6.0/.doctrees/clauses/remove.doctree | Bin 6630 -> 6630 bytes
docs/v0.6.0/.doctrees/clauses/return.doctree | Bin 21591 -> 21591 bytes
docs/v0.6.0/.doctrees/clauses/set.doctree | Bin 11952 -> 11952 bytes
docs/v0.6.0/.doctrees/clauses/skip.doctree | Bin 9537 -> 9537 bytes
docs/v0.6.0/.doctrees/clauses/with.doctree | Bin 11085 -> 11085 bytes
docs/v0.6.0/.doctrees/environment.pickle | Bin 136659 -> 136659 bytes
.../functions/aggregate_functions.doctree | Bin 57674 -> 57674 bytes
.../.doctrees/functions/list_functions.doctree | Bin 18988 -> 18988 bytes
.../functions/logarithmic_functions.doctree | Bin 16326 -> 16326 bytes
.../.doctrees/functions/numeric_functions.doctree | Bin 22628 -> 22628 bytes
.../functions/predicate_functions.doctree | Bin 6445 -> 6445 bytes
.../.doctrees/functions/scalar_functions.doctree | Bin 56296 -> 56296 bytes
.../.doctrees/functions/string_functions.doctree | Bin 47885 -> 47885 bytes
.../functions/trigonometric_functions.doctree | Bin 34567 -> 34567 bytes
.../.doctrees/functions/user_functions.doctree | Bin 4976 -> 4976 bytes
docs/v0.6.0/.doctrees/index.doctree | Bin 4122 -> 4122 bytes
docs/v0.6.0/.doctrees/intro/aggregation.doctree | Bin 27322 -> 27322 bytes
docs/v0.6.0/.doctrees/intro/comparability.doctree | Bin 32523 -> 32523 bytes
docs/v0.6.0/.doctrees/intro/cypher.doctree | Bin 10246 -> 10246 bytes
docs/v0.6.0/.doctrees/intro/graphs.doctree | Bin 11554 -> 11554 bytes
docs/v0.6.0/.doctrees/intro/operators.doctree | Bin 22257 -> 22257 bytes
docs/v0.6.0/.doctrees/intro/overview.doctree | Bin 4006 -> 4006 bytes
docs/v0.6.0/.doctrees/intro/precedence.doctree | Bin 7042 -> 7042 bytes
docs/v0.6.0/.doctrees/intro/setup.doctree | Bin 11024 -> 11024 bytes
docs/v0.6.0/.doctrees/intro/types.doctree | Bin 81184 -> 81184 bytes
79 files changed, 170 insertions(+), 7 deletions(-)
diff --git a/docs/master/.buildinfo b/docs/master/.buildinfo
index b29f610..2074d3f 100644
--- a/docs/master/.buildinfo
+++ b/docs/master/.buildinfo
@@ -1,4 +1,4 @@
# Sphinx build info version 1
# This file hashes the configuration used when building these files. When it is not found, a full rebuild will be done.
-config: 5f43caf7bdbc28b6e83491304b5ca382
+config: bd3f392857a28e24726ac20090eb395d
tags: 645f666f9bcd5a90fca523b33c5a78b7
diff --git a/docs/master/.doctrees/advanced/advanced.doctree b/docs/master/.doctrees/advanced/advanced.doctree
index 83f1214..bd611a5 100644
Binary files a/docs/master/.doctrees/advanced/advanced.doctree and b/docs/master/.doctrees/advanced/advanced.doctree differ
diff --git a/docs/master/.doctrees/advanced/advanced_overview.doctree b/docs/master/.doctrees/advanced/advanced_overview.doctree
index 44e7691..54ea7bc 100644
Binary files a/docs/master/.doctrees/advanced/advanced_overview.doctree and b/docs/master/.doctrees/advanced/advanced_overview.doctree differ
diff --git a/docs/master/.doctrees/advanced/plpgsql.doctree b/docs/master/.doctrees/advanced/plpgsql.doctree
index 844ac25..e1ad67e 100644
Binary files a/docs/master/.doctrees/advanced/plpgsql.doctree and b/docs/master/.doctrees/advanced/plpgsql.doctree differ
diff --git a/docs/master/.doctrees/advanced/prepared_statements.doctree b/docs/master/.doctrees/advanced/prepared_statements.doctree
index b8ac7ce..8de9629 100644
Binary files a/docs/master/.doctrees/advanced/prepared_statements.doctree and b/docs/master/.doctrees/advanced/prepared_statements.doctree differ
diff --git a/docs/master/.doctrees/advanced/sql_in_cypher.doctree b/docs/master/.doctrees/advanced/sql_in_cypher.doctree
index e7b0f95..ecd2c6e 100644
Binary files a/docs/master/.doctrees/advanced/sql_in_cypher.doctree and b/docs/master/.doctrees/advanced/sql_in_cypher.doctree differ
diff --git a/docs/master/.doctrees/clauses/create.doctree b/docs/master/.doctrees/clauses/create.doctree
index d6fee6d..c95ef0b 100644
Binary files a/docs/master/.doctrees/clauses/create.doctree and b/docs/master/.doctrees/clauses/create.doctree differ
diff --git a/docs/master/.doctrees/clauses/delete.doctree b/docs/master/.doctrees/clauses/delete.doctree
index 6cde859..54a4df5 100644
Binary files a/docs/master/.doctrees/clauses/delete.doctree and b/docs/master/.doctrees/clauses/delete.doctree differ
diff --git a/docs/master/.doctrees/clauses/limit.doctree b/docs/master/.doctrees/clauses/limit.doctree
index db32e85..cb45883 100644
Binary files a/docs/master/.doctrees/clauses/limit.doctree and b/docs/master/.doctrees/clauses/limit.doctree differ
diff --git a/docs/master/.doctrees/clauses/match.doctree b/docs/master/.doctrees/clauses/match.doctree
index 369d7f0..f180ace 100644
Binary files a/docs/master/.doctrees/clauses/match.doctree and b/docs/master/.doctrees/clauses/match.doctree differ
diff --git a/docs/master/.doctrees/clauses/order_by.doctree b/docs/master/.doctrees/clauses/order_by.doctree
index 4743e77..0b4dfc9 100644
Binary files a/docs/master/.doctrees/clauses/order_by.doctree and b/docs/master/.doctrees/clauses/order_by.doctree differ
diff --git a/docs/master/.doctrees/clauses/remove.doctree b/docs/master/.doctrees/clauses/remove.doctree
index 393c8a1..74801f2 100644
Binary files a/docs/master/.doctrees/clauses/remove.doctree and b/docs/master/.doctrees/clauses/remove.doctree differ
diff --git a/docs/master/.doctrees/clauses/return.doctree b/docs/master/.doctrees/clauses/return.doctree
index a335a1f..b73495f 100644
Binary files a/docs/master/.doctrees/clauses/return.doctree and b/docs/master/.doctrees/clauses/return.doctree differ
diff --git a/docs/master/.doctrees/clauses/set.doctree b/docs/master/.doctrees/clauses/set.doctree
index 0efc8b6..0acf710 100644
Binary files a/docs/master/.doctrees/clauses/set.doctree and b/docs/master/.doctrees/clauses/set.doctree differ
diff --git a/docs/master/.doctrees/clauses/skip.doctree b/docs/master/.doctrees/clauses/skip.doctree
index 57fe03b..a2bc5c4 100644
Binary files a/docs/master/.doctrees/clauses/skip.doctree and b/docs/master/.doctrees/clauses/skip.doctree differ
diff --git a/docs/master/.doctrees/clauses/with.doctree b/docs/master/.doctrees/clauses/with.doctree
index be14ed4..26d727d 100644
Binary files a/docs/master/.doctrees/clauses/with.doctree and b/docs/master/.doctrees/clauses/with.doctree differ
diff --git a/docs/master/.doctrees/environment.pickle b/docs/master/.doctrees/environment.pickle
index 544ed84..016f6ed 100644
Binary files a/docs/master/.doctrees/environment.pickle and b/docs/master/.doctrees/environment.pickle differ
diff --git a/docs/master/.doctrees/functions/aggregate_functions.doctree b/docs/master/.doctrees/functions/aggregate_functions.doctree
index 919dfa6..57a6c6c 100644
Binary files a/docs/master/.doctrees/functions/aggregate_functions.doctree and b/docs/master/.doctrees/functions/aggregate_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/list_functions.doctree b/docs/master/.doctrees/functions/list_functions.doctree
index 19390cf..25d4ce7 100644
Binary files a/docs/master/.doctrees/functions/list_functions.doctree and b/docs/master/.doctrees/functions/list_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/logarithmic_functions.doctree b/docs/master/.doctrees/functions/logarithmic_functions.doctree
index 6fd1d36..f72654f 100644
Binary files a/docs/master/.doctrees/functions/logarithmic_functions.doctree and b/docs/master/.doctrees/functions/logarithmic_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/numeric_functions.doctree b/docs/master/.doctrees/functions/numeric_functions.doctree
index 0c735b7..ba233f6 100644
Binary files a/docs/master/.doctrees/functions/numeric_functions.doctree and b/docs/master/.doctrees/functions/numeric_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/predicate_functions.doctree b/docs/master/.doctrees/functions/predicate_functions.doctree
index db0095d..1f3b45d 100644
Binary files a/docs/master/.doctrees/functions/predicate_functions.doctree and b/docs/master/.doctrees/functions/predicate_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/scalar_functions.doctree b/docs/master/.doctrees/functions/scalar_functions.doctree
index da52d55..4e56d76 100644
Binary files a/docs/master/.doctrees/functions/scalar_functions.doctree and b/docs/master/.doctrees/functions/scalar_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/string_functions.doctree b/docs/master/.doctrees/functions/string_functions.doctree
index 644ed3a..fb2e0a4 100644
Binary files a/docs/master/.doctrees/functions/string_functions.doctree and b/docs/master/.doctrees/functions/string_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/trigonometric_functions.doctree b/docs/master/.doctrees/functions/trigonometric_functions.doctree
index 85ba639..7536dea 100644
Binary files a/docs/master/.doctrees/functions/trigonometric_functions.doctree and b/docs/master/.doctrees/functions/trigonometric_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/user_functions.doctree b/docs/master/.doctrees/functions/user_functions.doctree
index 54aee1c..0c24d82 100644
Binary files a/docs/master/.doctrees/functions/user_functions.doctree and b/docs/master/.doctrees/functions/user_functions.doctree differ
diff --git a/docs/master/.doctrees/index.doctree b/docs/master/.doctrees/index.doctree
index 0a2cadb..eda0e86 100644
Binary files a/docs/master/.doctrees/index.doctree and b/docs/master/.doctrees/index.doctree differ
diff --git a/docs/master/.doctrees/intro/aggregation.doctree b/docs/master/.doctrees/intro/aggregation.doctree
index 8cafbb3..ccab9b1 100644
Binary files a/docs/master/.doctrees/intro/aggregation.doctree and b/docs/master/.doctrees/intro/aggregation.doctree differ
diff --git a/docs/master/.doctrees/intro/comparability.doctree b/docs/master/.doctrees/intro/comparability.doctree
index 670e29b..ba2d708 100644
Binary files a/docs/master/.doctrees/intro/comparability.doctree and b/docs/master/.doctrees/intro/comparability.doctree differ
diff --git a/docs/master/.doctrees/intro/cypher.doctree b/docs/master/.doctrees/intro/cypher.doctree
index 7ed9738..bd90fb4 100644
Binary files a/docs/master/.doctrees/intro/cypher.doctree and b/docs/master/.doctrees/intro/cypher.doctree differ
diff --git a/docs/master/.doctrees/intro/graphs.doctree b/docs/master/.doctrees/intro/graphs.doctree
index 159622c..4b5baf8 100644
Binary files a/docs/master/.doctrees/intro/graphs.doctree and b/docs/master/.doctrees/intro/graphs.doctree differ
diff --git a/docs/master/.doctrees/intro/operators.doctree b/docs/master/.doctrees/intro/operators.doctree
index 10426b1..ffdb710 100644
Binary files a/docs/master/.doctrees/intro/operators.doctree and b/docs/master/.doctrees/intro/operators.doctree differ
diff --git a/docs/master/.doctrees/intro/overview.doctree b/docs/master/.doctrees/intro/overview.doctree
index 78fb16e..44a3870 100644
Binary files a/docs/master/.doctrees/intro/overview.doctree and b/docs/master/.doctrees/intro/overview.doctree differ
diff --git a/docs/master/.doctrees/intro/precedence.doctree b/docs/master/.doctrees/intro/precedence.doctree
index 46f87ba..4078fc3 100644
Binary files a/docs/master/.doctrees/intro/precedence.doctree and b/docs/master/.doctrees/intro/precedence.doctree differ
diff --git a/docs/master/.doctrees/intro/setup.doctree b/docs/master/.doctrees/intro/setup.doctree
index 4cde882..01199b2 100644
Binary files a/docs/master/.doctrees/intro/setup.doctree and b/docs/master/.doctrees/intro/setup.doctree differ
diff --git a/docs/master/.doctrees/intro/types.doctree b/docs/master/.doctrees/intro/types.doctree
index f647690..baf0dab 100644
Binary files a/docs/master/.doctrees/intro/types.doctree and b/docs/master/.doctrees/intro/types.doctree differ
diff --git a/docs/master/_sources/clauses/match.md.txt b/docs/master/_sources/clauses/match.md.txt
index b75608a..28556c8 100644
--- a/docs/master/_sources/clauses/match.md.txt
+++ b/docs/master/_sources/clauses/match.md.txt
@@ -375,4 +375,41 @@ Returns the movie 'Charlie Sheen' acted in and its director.
</tr>
</table>
+### Edges in Depth
+
+#### Variable Length Edges
+
+When the connection between two vertices is of variable length, the list of edges that form the connection can be returned using the following connection.
+
+Query
+
+
+```
+SELECT * FROM cypher('graph_name', $$
+ MATCH p = (actor {name: 'Willam Defoe'})-[:ACTED_IN*2]-(co_actor)
+ RETURN relationships(p)
+$$) as (r agtype);
+```
+
+
+Returns the list of edges, including the one that Willam Defoe acted in and the two spidermens he worked with.
+
+
+<table>
+ <tr>
+ <td><strong>r</strong>
+ </td>
+ </tr>
+ <tr>
+ <td>[{id: 0; label:"ACTED_IN"; properties: {role: "Green Goblin"}}::edge, {id: 1; label: "ACTED_IN; properties: {role: "Spiderman", actor: "Toby Maguire}}::edge]
+ </td>
+ <td>[{id: 0; label:"ACTED_IN"; properties: {role: "Green Goblin"}}::edge, {id: 2; label: "ACTED_IN; properties: {role: "Spiderman", actor: "Andrew Garfield"}}::edge]
+ </td>
+ </td>
+ </tr>
+ <tr>
+ <td colspan="2" >2 row(s) returned
+ </td>
+ </tr>
+</table>
diff --git a/docs/master/_sources/functions/predicate_functions.md.txt b/docs/master/_sources/functions/predicate_functions.md.txt
index e65ab38..7c22b6f 100644
--- a/docs/master/_sources/functions/predicate_functions.md.txt
+++ b/docs/master/_sources/functions/predicate_functions.md.txt
@@ -74,4 +74,36 @@ Results:
</table>
-## Exists(Pattern) TODO
+## Exists(Path)
+
+EXISTS(path) returns true if for the given path, there already exists the given path.
+
+```
+SELECT *
+FROM cypher('graph_name', $$
+ MATCH (n)
+ WHERE exists(n)-[]-(name: 'Willem Defoe')
+ RETURN n.full_name
+$$) as (full_name agtype);
+```
+
+Results:
+<table>
+ <tr>
+ <td>full_name
+ </td>
+ </tr>
+ <tr>
+ <td>‘Toby Maguire'
+ </td>
+ </tr>
+ <tr>
+ <td>‘Tom Holland’
+ </td>
+ </tr>
+ <tr>
+ <td colspan="2" >2 row(s) returned
+ </td>
+ </tr>
+</table>
+
diff --git a/docs/master/_sources/intro/setup.md.txt b/docs/master/_sources/intro/setup.md.txt
index bf12b26..9daf32a 100644
--- a/docs/master/_sources/intro/setup.md.txt
+++ b/docs/master/_sources/intro/setup.md.txt
@@ -68,3 +68,17 @@ We recommend adding ag_catalog to your search_path to simplify your queries. The
```postgresql
SET search_path = ag_catalog, "$user", public;
```
+
+### Optional: allow non-superusers to use Apache AGE
+
+* Non-superusers can only apply LOAD to library files located in `$libdir/plugins/` (see <https://www.postgresql.org/docs/11/sql-load.html>). A symlink can be created to allow non-superusers to LOAD the Apache AGE library:
+
+```console
+sudo ln -s /usr/lib/postgresql/11/lib/age.so /usr/lib/postgresql/11/lib/plugins/age.so
+```
+
+* In order to use Apache AGE, users need `USAGE` privileges on the `ag_catalog` schema (example for user `db_user`):
+
+```postgresql
+GRANT USAGE ON SCHEMA ag_catalog TO db_user;
+```
diff --git a/docs/master/clauses/match.html b/docs/master/clauses/match.html
index 807200b..4df2139 100644
--- a/docs/master/clauses/match.html
+++ b/docs/master/clauses/match.html
@@ -120,6 +120,10 @@
<li class="toctree-l3"><a class="reference internal" href="#match-on-edge-type">Match on edge type</a></li>
<li class="toctree-l3"><a class="reference internal" href="#match-on-edge-type-and-use-a-variable">Match on edge type and use a variable</a></li>
<li class="toctree-l3"><a class="reference internal" href="#multiple-edges">Multiple Edges</a></li>
+<li class="toctree-l3"><a class="reference internal" href="#edges-in-depth">Edges in Depth</a><ul>
+<li class="toctree-l4"><a class="reference internal" href="#variable-length-edges">Variable Length Edges</a></li>
+</ul>
+</li>
</ul>
</li>
</ul>
@@ -517,6 +521,38 @@ $$) as (title agtype, name agtype);
</tr>
</table>
</div>
+<div class="section" id="edges-in-depth">
+<h3>Edges in Depth<a class="headerlink" href="#edges-in-depth" title="Permalink to this headline">¶</a></h3>
+<div class="section" id="variable-length-edges">
+<h4>Variable Length Edges<a class="headerlink" href="#variable-length-edges" title="Permalink to this headline">¶</a></h4>
+<p>When the connection between two vertices is of variable length, the list of edges that form the connection can be returned using the following connection.</p>
+<p>Query</p>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>SELECT * FROM cypher('graph_name', $$
+ MATCH p = (actor {name: 'Willam Defoe'})-[:ACTED_IN*2]-(co_actor)
+ RETURN relationships(p)
+$$) as (r agtype);
+</pre></div>
+</div>
+<p>Returns the list of edges, including the one that Willam Defoe acted in and the two spidermens he worked with.</p>
+<table>
+ <tr>
+ <td><strong>r</strong>
+ </td>
+ </tr>
+ <tr>
+ <td>[{id: 0; label:"ACTED_IN"; properties: {role: "Green Goblin"}}::edge, {id: 1; label: "ACTED_IN; properties: {role: "Spiderman", actor: "Toby Maguire}}::edge]
+ </td>
+ <td>[{id: 0; label:"ACTED_IN"; properties: {role: "Green Goblin"}}::edge, {id: 2; label: "ACTED_IN; properties: {role: "Spiderman", actor: "Andrew Garfield"}}::edge]
+ </td>
+ </td>
+ </tr>
+ <tr>
+ <td colspan="2" >2 row(s) returned
+ </td>
+ </tr>
+</table>
+</div>
+</div>
</div>
</div>
diff --git a/docs/master/functions/predicate_functions.html b/docs/master/functions/predicate_functions.html
index 4335dde..a6e2ebc 100644
--- a/docs/master/functions/predicate_functions.html
+++ b/docs/master/functions/predicate_functions.html
@@ -121,7 +121,7 @@
<ul class="current">
<li class="toctree-l1 current"><a class="current reference internal" href="#">Predicate Functions</a><ul>
<li class="toctree-l2"><a class="reference internal" href="#exists-property">Exists(Property)</a></li>
-<li class="toctree-l2"><a class="reference internal" href="#exists-pattern-todo">Exists(Pattern) TODO</a></li>
+<li class="toctree-l2"><a class="reference internal" href="#exists-path">Exists(Path)</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="scalar_functions.html">Scalar Functions</a></li>
@@ -270,8 +270,36 @@ $$) as (first_name agtype, last_name agtype);
</tr>
</table>
</div>
-<div class="section" id="exists-pattern-todo">
-<h2>Exists(Pattern) TODO<a class="headerlink" href="#exists-pattern-todo" title="Permalink to this headline">¶</a></h2>
+<div class="section" id="exists-path">
+<h2>Exists(Path)<a class="headerlink" href="#exists-path" title="Permalink to this headline">¶</a></h2>
+<p>EXISTS(path) returns true if for the given path, there already exists the given path.</p>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>SELECT *
+FROM cypher('graph_name', $$
+ MATCH (n)
+ WHERE exists(n)-[]-(name: 'Willem Defoe')
+ RETURN n.full_name
+$$) as (full_name agtype);
+</pre></div>
+</div>
+<p>Results:</p>
+<table>
+ <tr>
+ <td>full_name
+ </td>
+ </tr>
+ <tr>
+ <td>‘Toby Maguire'
+ </td>
+ </tr>
+ <tr>
+ <td>‘Tom Holland’
+ </td>
+ </tr>
+ <tr>
+ <td colspan="2" >2 row(s) returned
+ </td>
+ </tr>
+</table>
</div>
</div>
diff --git a/docs/master/intro/setup.html b/docs/master/intro/setup.html
index de43094..3633653 100644
--- a/docs/master/intro/setup.html
+++ b/docs/master/intro/setup.html
@@ -112,6 +112,7 @@
<li class="toctree-l2"><a class="reference internal" href="#post-installation">Post Installation</a><ul>
<li class="toctree-l3"><a class="reference internal" href="#per-installation-instructions">Per Installation Instructions</a></li>
<li class="toctree-l3"><a class="reference internal" href="#per-session-instructions">Per Session Instructions</a></li>
+<li class="toctree-l3"><a class="reference internal" href="#optional-allow-non-superusers-to-use-apache-age">Optional: allow non-superusers to use Apache AGE</a></li>
</ul>
</li>
</ul>
@@ -292,6 +293,21 @@ Building AGE from source depends on the following Linux libraries (Ubuntu packag
</pre></div>
</div>
</div>
+<div class="section" id="optional-allow-non-superusers-to-use-apache-age">
+<h3>Optional: allow non-superusers to use Apache AGE<a class="headerlink" href="#optional-allow-non-superusers-to-use-apache-age" title="Permalink to this headline">¶</a></h3>
+<ul class="simple">
+<li><p>Non-superusers can only apply LOAD to library files located in <code class="docutils literal notranslate"><span class="pre">$libdir/plugins/</span></code> (see <a class="reference external" href="https://www.postgresql.org/docs/11/sql-load.html">https://www.postgresql.org/docs/11/sql-load.html</a>). A symlink can be created to allow non-superusers to LOAD the Apache AGE library:</p></li>
+</ul>
+<div class="highlight-console notranslate"><div class="highlight"><pre><span></span><span class="go">sudo ln -s /usr/lib/postgresql/11/lib/age.so /usr/lib/postgresql/11/lib/plugins/age.so</span>
+</pre></div>
+</div>
+<ul class="simple">
+<li><p>In order to use Apache AGE, users need <code class="docutils literal notranslate"><span class="pre">USAGE</span></code> privileges on the <code class="docutils literal notranslate"><span class="pre">ag_catalog</span></code> schema (example for user <code class="docutils literal notranslate"><span class="pre">db_user</span></code>):</p></li>
+</ul>
+<div class="highlight-postgresql notranslate"><div class="highlight"><pre><span></span><span class="k">GRANT</span> <span class="n">USAGE</span> <span class="k">ON</span> <span class="k">SCHEMA</span> <span class="n">ag_catalog</span> <span class="k">TO</span> <span class="n">db_user</span><span class="p">;</span>
+</pre></div>
+</div>
+</div>
</div>
</div>
diff --git a/docs/master/searchindex.js b/docs/master/searchindex.js
index 4400984..123118f 100644
--- a/docs/master/searchindex.js
+++ b/docs/master/searchindex.js
@@ -1 +1 @@
-Search.setIndex({docnames:["advanced/advanced","advanced/advanced_overview","advanced/plpgsql","advanced/prepared_statements","advanced/sql_in_cypher","clauses/create","clauses/delete","clauses/limit","clauses/match","clauses/order_by","clauses/remove","clauses/return","clauses/set","clauses/skip","clauses/with","functions/aggregate_functions","functions/list_functions","functions/logarithmic_functions","functions/numeric_functions","functions/predicate_functions","functions/scalar_funct [...]
\ No newline at end of file
+Search.setIndex({docnames:["advanced/advanced","advanced/advanced_overview","advanced/plpgsql","advanced/prepared_statements","advanced/sql_in_cypher","clauses/create","clauses/delete","clauses/limit","clauses/match","clauses/order_by","clauses/remove","clauses/return","clauses/set","clauses/skip","clauses/with","functions/aggregate_functions","functions/list_functions","functions/logarithmic_functions","functions/numeric_functions","functions/predicate_functions","functions/scalar_funct [...]
\ No newline at end of file
diff --git a/docs/v0.6.0/.buildinfo b/docs/v0.6.0/.buildinfo
index 128a769..2ab0c0f 100644
--- a/docs/v0.6.0/.buildinfo
+++ b/docs/v0.6.0/.buildinfo
@@ -1,4 +1,4 @@
# Sphinx build info version 1
# This file hashes the configuration used when building these files. When it is not found, a full rebuild will be done.
-config: b5bb046b9997da94da591f67f5b0523d
+config: 59bd60602f528c03ef899c9c9f02423e
tags: 645f666f9bcd5a90fca523b33c5a78b7
diff --git a/docs/v0.6.0/.doctrees/advanced/advanced.doctree b/docs/v0.6.0/.doctrees/advanced/advanced.doctree
index 83f1214..c515153 100644
Binary files a/docs/v0.6.0/.doctrees/advanced/advanced.doctree and b/docs/v0.6.0/.doctrees/advanced/advanced.doctree differ
diff --git a/docs/v0.6.0/.doctrees/advanced/advanced_overview.doctree b/docs/v0.6.0/.doctrees/advanced/advanced_overview.doctree
index 44e7691..e0c7e85 100644
Binary files a/docs/v0.6.0/.doctrees/advanced/advanced_overview.doctree and b/docs/v0.6.0/.doctrees/advanced/advanced_overview.doctree differ
diff --git a/docs/v0.6.0/.doctrees/advanced/plpgsql.doctree b/docs/v0.6.0/.doctrees/advanced/plpgsql.doctree
index 844ac25..0693c39 100644
Binary files a/docs/v0.6.0/.doctrees/advanced/plpgsql.doctree and b/docs/v0.6.0/.doctrees/advanced/plpgsql.doctree differ
diff --git a/docs/v0.6.0/.doctrees/advanced/prepared_statements.doctree b/docs/v0.6.0/.doctrees/advanced/prepared_statements.doctree
index b8ac7ce..35095a5 100644
Binary files a/docs/v0.6.0/.doctrees/advanced/prepared_statements.doctree and b/docs/v0.6.0/.doctrees/advanced/prepared_statements.doctree differ
diff --git a/docs/v0.6.0/.doctrees/advanced/sql_in_cypher.doctree b/docs/v0.6.0/.doctrees/advanced/sql_in_cypher.doctree
index e7b0f95..1219504 100644
Binary files a/docs/v0.6.0/.doctrees/advanced/sql_in_cypher.doctree and b/docs/v0.6.0/.doctrees/advanced/sql_in_cypher.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/create.doctree b/docs/v0.6.0/.doctrees/clauses/create.doctree
index d6fee6d..f3696a4 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/create.doctree and b/docs/v0.6.0/.doctrees/clauses/create.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/delete.doctree b/docs/v0.6.0/.doctrees/clauses/delete.doctree
index 6cde859..028c78e 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/delete.doctree and b/docs/v0.6.0/.doctrees/clauses/delete.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/limit.doctree b/docs/v0.6.0/.doctrees/clauses/limit.doctree
index db32e85..b9de555 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/limit.doctree and b/docs/v0.6.0/.doctrees/clauses/limit.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/match.doctree b/docs/v0.6.0/.doctrees/clauses/match.doctree
index 369d7f0..6300bd6 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/match.doctree and b/docs/v0.6.0/.doctrees/clauses/match.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/order_by.doctree b/docs/v0.6.0/.doctrees/clauses/order_by.doctree
index 4743e77..73975fc 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/order_by.doctree and b/docs/v0.6.0/.doctrees/clauses/order_by.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/remove.doctree b/docs/v0.6.0/.doctrees/clauses/remove.doctree
index 393c8a1..c5cc098 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/remove.doctree and b/docs/v0.6.0/.doctrees/clauses/remove.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/return.doctree b/docs/v0.6.0/.doctrees/clauses/return.doctree
index a335a1f..5a9b758 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/return.doctree and b/docs/v0.6.0/.doctrees/clauses/return.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/set.doctree b/docs/v0.6.0/.doctrees/clauses/set.doctree
index 0efc8b6..dfceece 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/set.doctree and b/docs/v0.6.0/.doctrees/clauses/set.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/skip.doctree b/docs/v0.6.0/.doctrees/clauses/skip.doctree
index 57fe03b..da4b2b9 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/skip.doctree and b/docs/v0.6.0/.doctrees/clauses/skip.doctree differ
diff --git a/docs/v0.6.0/.doctrees/clauses/with.doctree b/docs/v0.6.0/.doctrees/clauses/with.doctree
index be14ed4..52f63bc 100644
Binary files a/docs/v0.6.0/.doctrees/clauses/with.doctree and b/docs/v0.6.0/.doctrees/clauses/with.doctree differ
diff --git a/docs/v0.6.0/.doctrees/environment.pickle b/docs/v0.6.0/.doctrees/environment.pickle
index 9bd54b3..612a03e 100644
Binary files a/docs/v0.6.0/.doctrees/environment.pickle and b/docs/v0.6.0/.doctrees/environment.pickle differ
diff --git a/docs/v0.6.0/.doctrees/functions/aggregate_functions.doctree b/docs/v0.6.0/.doctrees/functions/aggregate_functions.doctree
index 919dfa6..7f7ae5d 100644
Binary files a/docs/v0.6.0/.doctrees/functions/aggregate_functions.doctree and b/docs/v0.6.0/.doctrees/functions/aggregate_functions.doctree differ
diff --git a/docs/v0.6.0/.doctrees/functions/list_functions.doctree b/docs/v0.6.0/.doctrees/functions/list_functions.doctree
index 19390cf..be89061 100644
Binary files a/docs/v0.6.0/.doctrees/functions/list_functions.doctree and b/docs/v0.6.0/.doctrees/functions/list_functions.doctree differ
diff --git a/docs/v0.6.0/.doctrees/functions/logarithmic_functions.doctree b/docs/v0.6.0/.doctrees/functions/logarithmic_functions.doctree
index 6fd1d36..4d03785 100644
Binary files a/docs/v0.6.0/.doctrees/functions/logarithmic_functions.doctree and b/docs/v0.6.0/.doctrees/functions/logarithmic_functions.doctree differ
diff --git a/docs/v0.6.0/.doctrees/functions/numeric_functions.doctree b/docs/v0.6.0/.doctrees/functions/numeric_functions.doctree
index 0c735b7..ea2d8c0 100644
Binary files a/docs/v0.6.0/.doctrees/functions/numeric_functions.doctree and b/docs/v0.6.0/.doctrees/functions/numeric_functions.doctree differ
diff --git a/docs/v0.6.0/.doctrees/functions/predicate_functions.doctree b/docs/v0.6.0/.doctrees/functions/predicate_functions.doctree
index db0095d..125bd41 100644
Binary files a/docs/v0.6.0/.doctrees/functions/predicate_functions.doctree and b/docs/v0.6.0/.doctrees/functions/predicate_functions.doctree differ
diff --git a/docs/v0.6.0/.doctrees/functions/scalar_functions.doctree b/docs/v0.6.0/.doctrees/functions/scalar_functions.doctree
index da52d55..6b1109e 100644
Binary files a/docs/v0.6.0/.doctrees/functions/scalar_functions.doctree and b/docs/v0.6.0/.doctrees/functions/scalar_functions.doctree differ
diff --git a/docs/v0.6.0/.doctrees/functions/string_functions.doctree b/docs/v0.6.0/.doctrees/functions/string_functions.doctree
index 644ed3a..b84a8fd 100644
Binary files a/docs/v0.6.0/.doctrees/functions/string_functions.doctree and b/docs/v0.6.0/.doctrees/functions/string_functions.doctree differ
diff --git a/docs/v0.6.0/.doctrees/functions/trigonometric_functions.doctree b/docs/v0.6.0/.doctrees/functions/trigonometric_functions.doctree
index 85ba639..dbf463b 100644
Binary files a/docs/v0.6.0/.doctrees/functions/trigonometric_functions.doctree and b/docs/v0.6.0/.doctrees/functions/trigonometric_functions.doctree differ
diff --git a/docs/v0.6.0/.doctrees/functions/user_functions.doctree b/docs/v0.6.0/.doctrees/functions/user_functions.doctree
index 54aee1c..79b8c2c 100644
Binary files a/docs/v0.6.0/.doctrees/functions/user_functions.doctree and b/docs/v0.6.0/.doctrees/functions/user_functions.doctree differ
diff --git a/docs/v0.6.0/.doctrees/index.doctree b/docs/v0.6.0/.doctrees/index.doctree
index 0a2cadb..f051111 100644
Binary files a/docs/v0.6.0/.doctrees/index.doctree and b/docs/v0.6.0/.doctrees/index.doctree differ
diff --git a/docs/v0.6.0/.doctrees/intro/aggregation.doctree b/docs/v0.6.0/.doctrees/intro/aggregation.doctree
index 8cafbb3..fd67d0e 100644
Binary files a/docs/v0.6.0/.doctrees/intro/aggregation.doctree and b/docs/v0.6.0/.doctrees/intro/aggregation.doctree differ
diff --git a/docs/v0.6.0/.doctrees/intro/comparability.doctree b/docs/v0.6.0/.doctrees/intro/comparability.doctree
index 670e29b..d0dae26 100644
Binary files a/docs/v0.6.0/.doctrees/intro/comparability.doctree and b/docs/v0.6.0/.doctrees/intro/comparability.doctree differ
diff --git a/docs/v0.6.0/.doctrees/intro/cypher.doctree b/docs/v0.6.0/.doctrees/intro/cypher.doctree
index 7ed9738..2343258 100644
Binary files a/docs/v0.6.0/.doctrees/intro/cypher.doctree and b/docs/v0.6.0/.doctrees/intro/cypher.doctree differ
diff --git a/docs/v0.6.0/.doctrees/intro/graphs.doctree b/docs/v0.6.0/.doctrees/intro/graphs.doctree
index 159622c..300fa18 100644
Binary files a/docs/v0.6.0/.doctrees/intro/graphs.doctree and b/docs/v0.6.0/.doctrees/intro/graphs.doctree differ
diff --git a/docs/v0.6.0/.doctrees/intro/operators.doctree b/docs/v0.6.0/.doctrees/intro/operators.doctree
index 10426b1..62f732d 100644
Binary files a/docs/v0.6.0/.doctrees/intro/operators.doctree and b/docs/v0.6.0/.doctrees/intro/operators.doctree differ
diff --git a/docs/v0.6.0/.doctrees/intro/overview.doctree b/docs/v0.6.0/.doctrees/intro/overview.doctree
index 78fb16e..494a647 100644
Binary files a/docs/v0.6.0/.doctrees/intro/overview.doctree and b/docs/v0.6.0/.doctrees/intro/overview.doctree differ
diff --git a/docs/v0.6.0/.doctrees/intro/precedence.doctree b/docs/v0.6.0/.doctrees/intro/precedence.doctree
index 46f87ba..2aa069d 100644
Binary files a/docs/v0.6.0/.doctrees/intro/precedence.doctree and b/docs/v0.6.0/.doctrees/intro/precedence.doctree differ
diff --git a/docs/v0.6.0/.doctrees/intro/setup.doctree b/docs/v0.6.0/.doctrees/intro/setup.doctree
index 4cde882..678c995 100644
Binary files a/docs/v0.6.0/.doctrees/intro/setup.doctree and b/docs/v0.6.0/.doctrees/intro/setup.doctree differ
diff --git a/docs/v0.6.0/.doctrees/intro/types.doctree b/docs/v0.6.0/.doctrees/intro/types.doctree
index f647690..579c2d0 100644
Binary files a/docs/v0.6.0/.doctrees/intro/types.doctree and b/docs/v0.6.0/.doctrees/intro/types.doctree differ