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 17:47:48 UTC
[incubator-age-website] branch asf-site updated: deploy: 080324d81ecb4310ba5fb29ac84f10c4a160c05e
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 32e95e4 deploy: 080324d81ecb4310ba5fb29ac84f10c4a160c05e
32e95e4 is described below
commit 32e95e43fd07f858e4dd28b8d33f031ceabf040b
Author: JoshInnis <Jo...@users.noreply.github.com>
AuthorDate: Mon Jan 17 17:47:44 2022 +0000
deploy: 080324d81ecb4310ba5fb29ac84f10c4a160c05e
---
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 4544 -> 8393 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 28036 -> 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 136366 -> 136366 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 7764 -> 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 14235 -> 14235 bytes
docs/master/.doctrees/intro/types.doctree | Bin 81184 -> 81184 bytes
docs/master/_sources/advanced/plpgsql.md.txt | 67 +++++++++++++++++++--
docs/master/advanced/plpgsql.html | 64 ++++++++++++++++++--
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
75 files changed, 122 insertions(+), 15 deletions(-)
diff --git a/docs/master/.buildinfo b/docs/master/.buildinfo
index 558ec76..b70e579 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: 68fe9dc16df33e9941f08f2671c30985
+config: 07bb740a9a440a57f8181f3156abbbf4
tags: 645f666f9bcd5a90fca523b33c5a78b7
diff --git a/docs/master/.doctrees/advanced/advanced.doctree b/docs/master/.doctrees/advanced/advanced.doctree
index aeb8035..46a5493 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 cc0acc6..1c00119 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 cb10eda..610663e 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 d0d6533..d61d1ef 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 29a23d1..a4278ca 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 a3fd998..2da6877 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 f75b54a..1c2cbad 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 5ac3cde..e21e539 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 81e13db..e77810d 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 edac8a5..0769af6 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 1429e64..4c51d6b 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 96d7781..b4950b5 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 0318078..ade32a8 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 c986685..85e0305 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 972f28a..8b53aaa 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 f57e80a..a55a32e 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 e7964d4..eee76ee 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 727d822..c3c5b99 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 d846b85..9290b8a 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 7470ebd..3a96f39 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 2248477..bdc0700 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 4fb366c..4bbaa7d 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 cde971c..8921a5e 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 7546eee..2a1b95b 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 48fedd3..7277f4d 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 8620ed1..5b4bb76 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 18edc46..0fded8d 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 c907a95..eef48c3 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 fce5ad7..021715e 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 a1ce4d3..31a9b6a 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 f7e84e0..dbfe235 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 6f4bb56..42932a6 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 47bb50e..8dc753b 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 c41f0e2..24f412a 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 868058e..434fc40 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/advanced/plpgsql.md.txt b/docs/master/_sources/advanced/plpgsql.md.txt
index a78bd63..78a5527 100644
--- a/docs/master/_sources/advanced/plpgsql.md.txt
+++ b/docs/master/_sources/advanced/plpgsql.md.txt
@@ -2,9 +2,35 @@
Cypher commands can be run in [PL/pgSQL](https://www.postgresql.org/docs/11/plpgsql-overview.html) functions without restriction.
+Data Setup
```
-CREATE FUNCTION get_all_vertices()
-RETURNS TABLE(vertex ag_catalog.agtype)
+SELECT *
+FROM cypher('imdb', $$
+ CREATE (toby:actor {name: 'Toby Maguire'}),
+ (tom:actor {name: 'Tom Holland'}),
+ (willam:actor {name: 'Willam Dafoe'}),
+ (robert:actor {name: 'Robert Downey Jr'}),
+ (spiderman:movie {title: 'Spiderman'}),
+ (no_way_home:movie {title: 'Spiderman: No Way Home'}),
+ (homecoming:movie {title: 'Spiderman: Homecoming'}),
+ (ironman:movie {title: 'Ironman'}),
+ (tropic_thunder:movie {title: 'Tropic Thunder'}),
+ (toby)-[:acted_in {role: 'Peter Parker', alter_ego: 'Spiderman'}]->(spiderman),
+ (willam)-[:acted_in {role: 'Norman Osborn', alter_ego: 'Green Goblin'}]->(spiderman),
+ (toby)-[:acted_in {role: 'Toby Maguire'}]->(tropic_thunder),
+ (robert)-[:acted_in {role: 'Kirk Lazarus'}]->(tropic_thunder),
+ (robert)-[:acted_in {role: 'Tony Stark', alter_ego: 'Ironman'}]->(homecoming),
+ (tom)-[:acted_in {role: 'Peter Parker', alter_ego: 'Spiderman'}]->(homecoming),
+ (tom)-[:acted_in {role: 'Peter Parker', alter_ego: 'Spiderman'}]->(no_way_home),
+ (toby)-[:acted_in {role: 'Peter Parker', alter_ego: 'Spiderman'}]->(no_way_home),
+ (willam)-[:acted_in {role: 'Norman Osborn', alter_ego: 'Green Goblin'}]->(no_way_home)
+$$) AS (a agtype);
+```
+
+Function Creation
+```
+CREATE OR REPLACE FUNCTION get_all_actor_names()
+RETURNS TABLE(actor agtype)
LANGUAGE plpgsql
AS $BODY$
BEGIN
@@ -13,14 +39,43 @@ BEGIN
RETURN QUERY
SELECT *
- FROM ag_catalog.cypher('graph_name', $$
- MATCH (v)
- RETURN v
- $$) AS (a ag_catalog.agtype);
+ FROM ag_catalog.cypher('imdb', $$
+ MATCH (v:actor)
+ RETURN v.name
+ $$) AS (a agtype);
END
$BODY$;
```
+Query:
+```
+SELECT * FROM get_all_actor_names();
+```
+
+Results
+<table>
+ <tr>
+ <td><strong>title</strong>
+ </td>
+ </tr>
+ <tr>
+ <td>"Toby Maguire"</td>
+ </tr>
+ <tr>
+ <td>"Tom Holland"</td>
+ </tr>
+ <tr>
+ <td>"Willam Dafoe"</td>
+ </tr>
+ <tr>
+ <td>"Robert Downey Jr"</td>
+ </tr>
+ <tr>
+ <td>4 row(s) returned
+ </td>
+ </tr>
+</table>
+
```
Developer's Note:
diff --git a/docs/master/advanced/plpgsql.html b/docs/master/advanced/plpgsql.html
index 8be063f..e148339 100644
--- a/docs/master/advanced/plpgsql.html
+++ b/docs/master/advanced/plpgsql.html
@@ -210,8 +210,33 @@
<div class="tex2jax_ignore mathjax_ignore section" id="pl-pgsql-functions">
<h1>PL/pgSQL Functions<a class="headerlink" href="#pl-pgsql-functions" title="Permalink to this headline">ΒΆ</a></h1>
<p>Cypher commands can be run in <a class="reference external" href="https://www.postgresql.org/docs/11/plpgsql-overview.html">PL/pgSQL</a> functions without restriction.</p>
-<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>CREATE FUNCTION get_all_vertices()
-RETURNS TABLE(vertex ag_catalog.agtype)
+<p>Data Setup</p>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>SELECT *
+FROM cypher('imdb', $$
+ CREATE (toby:actor {name: 'Toby Maguire'}),
+ (tom:actor {name: 'Tom Holland'}),
+ (willam:actor {name: 'Willam Dafoe'}),
+ (robert:actor {name: 'Robert Downey Jr'}),
+ (spiderman:movie {title: 'Spiderman'}),
+ (no_way_home:movie {title: 'Spiderman: No Way Home'}),
+ (homecoming:movie {title: 'Spiderman: Homecoming'}),
+ (ironman:movie {title: 'Ironman'}),
+ (tropic_thunder:movie {title: 'Tropic Thunder'}),
+ (toby)-[:acted_in {role: 'Peter Parker', alter_ego: 'Spiderman'}]->(spiderman),
+ (willam)-[:acted_in {role: 'Norman Osborn', alter_ego: 'Green Goblin'}]->(spiderman),
+ (toby)-[:acted_in {role: 'Toby Maguire'}]->(tropic_thunder),
+ (robert)-[:acted_in {role: 'Kirk Lazarus'}]->(tropic_thunder),
+ (robert)-[:acted_in {role: 'Tony Stark', alter_ego: 'Ironman'}]->(homecoming),
+ (tom)-[:acted_in {role: 'Peter Parker', alter_ego: 'Spiderman'}]->(homecoming),
+ (tom)-[:acted_in {role: 'Peter Parker', alter_ego: 'Spiderman'}]->(no_way_home),
+ (toby)-[:acted_in {role: 'Peter Parker', alter_ego: 'Spiderman'}]->(no_way_home),
+ (willam)-[:acted_in {role: 'Norman Osborn', alter_ego: 'Green Goblin'}]->(no_way_home)
+$$) AS (a agtype);
+</pre></div>
+</div>
+<p>Function Creation</p>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>CREATE OR REPLACE FUNCTION get_all_actor_names()
+RETURNS TABLE(actor agtype)
LANGUAGE plpgsql
AS $BODY$
BEGIN
@@ -220,14 +245,41 @@ BEGIN
RETURN QUERY
SELECT *
- FROM ag_catalog.cypher('graph_name', $$
- MATCH (v)
- RETURN v
- $$) AS (a ag_catalog.agtype);
+ FROM ag_catalog.cypher('imdb', $$
+ MATCH (v:actor)
+ RETURN v.name
+ $$) AS (a agtype);
END
$BODY$;
</pre></div>
</div>
+<p>Query:</p>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">SELECT</span> <span class="o">*</span> <span class="n">FROM</span> <span class="n">get_all_actor_names</span><span class="p">();</span>
+</pre></div>
+</div>
+<p>Results</p>
+<table>
+ <tr>
+ <td><strong>title</strong>
+ </td>
+ </tr>
+ <tr>
+ <td>"Toby Maguire"</td>
+ </tr>
+ <tr>
+ <td>"Tom Holland"</td>
+ </tr>
+ <tr>
+ <td>"Willam Dafoe"</td>
+ </tr>
+ <tr>
+ <td>"Robert Downey Jr"</td>
+ </tr>
+ <tr>
+ <td>4 row(s) returned
+ </td>
+ </tr>
+</table>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">Developer</span><span class="s1">'s Note:</span>
<span class="n">It</span><span class="s1">'s recommended that the LOAD '</span><span class="n">age</span><span class="s1">' command and setting the search_path in the function declaration, to ensure the CREATE FUNCTION command works consistently.</span>
diff --git a/docs/master/searchindex.js b/docs/master/searchindex.js
index ff4fd0b..dbb2dcc 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 e4e9263..0f8f684 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: 01219913e6655ee90fa0a8ee2da1a812
+config: 297c5c9cc2780291d4cf5cb55ffdd262
tags: 645f666f9bcd5a90fca523b33c5a78b7
diff --git a/docs/v0.6.0/.doctrees/advanced/advanced.doctree b/docs/v0.6.0/.doctrees/advanced/advanced.doctree
index f54ca42..74eed79 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 527b790..c6d6a1d 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 a02ce33..8d03302 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 0becc2d..c051f54 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 5fa3495..bab7ad8 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 15ad61e..7eb1b7d 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 ac6a1ba..a52bb91 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 cffa2af..037682c 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 687e064..6c57271 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 7510007..2b9f747 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 db8c3ab..55b3918 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 6772495..922fd4c 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 33b14d2..37d85a9 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 23953f9..4734fe1 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 c0edf5c..06756ea 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 b91e072..b8850d5 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 f2b78fc..4824e13 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 be80af1..b710775 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 53fffd9..62d09ac 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 dbe5e58..160673a 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 6cd2307..98c6262 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 a6593bc..7c38928 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 958c821..b77363f 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 2ecc54e..b5e003f 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 2490f19..1feb43b 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 1f6f873..c6d297e 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 7e21940..a121ea3 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 df314a9..98f25dd 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 5ebfbec..d71b717 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 b6fd758..f2af1ff 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 7870c1d..f38589a 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 d33de0c..6d93e1e 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 3dc9d05..fc3a76d 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 cb9e35e..0f0f60c 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 d607324..c8344ce 100644
Binary files a/docs/v0.6.0/.doctrees/intro/types.doctree and b/docs/v0.6.0/.doctrees/intro/types.doctree differ