You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@age.apache.org by jo...@apache.org on 2021/10/20 18:46:49 UTC
[incubator-age-website] branch asf-site updated: Added Skip Clause
This is an automated email from the ASF dual-hosted git repository.
joshinnis 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 540e9bc Added Skip Clause
540e9bc is described below
commit 540e9bceecfc4bb20b18e661075ac6e8ca6c1a74
Author: Josh Innis <Jo...@gmail.com>
AuthorDate: Wed Oct 20 11:46:21 2021 -0700
Added Skip Clause
---
docs/_sources/clauses/limit.md.txt | 42 +++++++++
docs/_sources/clauses/skip.md.txt | 136 ++++++++++++++++++++++++++++
docs/_sources/index.rst.txt | 1 +
docs/advanced/advanced.html | 1 +
docs/advanced/advanced_overview.html | 1 +
docs/advanced/plpgsql.html | 1 +
docs/advanced/prepared_statements.html | 1 +
docs/clauses/create.html | 1 +
docs/clauses/delete.html | 1 +
docs/clauses/limit.html | 41 ++++++++-
docs/clauses/match.html | 1 +
docs/clauses/order_by.html | 5 +-
docs/clauses/remove.html | 1 +
docs/clauses/return.html | 1 +
docs/clauses/set.html | 1 +
docs/clauses/{limit.html => skip.html} | 107 ++++++++++++++++++----
docs/clauses/with.html | 1 +
docs/functions/aggregate_functions.html | 1 +
docs/functions/list_functions.html | 1 +
docs/functions/logarithmic_functions.html | 1 +
docs/functions/numeric_functions.html | 1 +
docs/functions/predicate_functions.html | 1 +
docs/functions/scalar_functions.html | 1 +
docs/functions/string_functions.html | 1 +
docs/functions/trigonometric_functions.html | 1 +
docs/functions/user_functions.html | 1 +
docs/genindex.html | 1 +
docs/index.html | 2 +
docs/intro/aggregation.html | 1 +
docs/intro/comparability.html | 1 +
docs/intro/cypher.html | 1 +
docs/intro/graphs.html | 1 +
docs/intro/overview.html | 1 +
docs/intro/precedence.html | 1 +
docs/intro/setup.html | 1 +
docs/intro/types.html | 1 +
docs/objects.inv | 5 +-
docs/search.html | 1 +
docs/searchindex.js | 2 +-
docs/src/docs/clauses/skip.md | 136 ++++++++++++++++++++++++++++
docs/src/docs/index.rst | 1 +
41 files changed, 482 insertions(+), 26 deletions(-)
diff --git a/docs/_sources/clauses/limit.md.txt b/docs/_sources/clauses/limit.md.txt
index 1f6f3f6..6f215c4 100644
--- a/docs/_sources/clauses/limit.md.txt
+++ b/docs/_sources/clauses/limit.md.txt
@@ -51,3 +51,45 @@ Result
</td>
</tr>
</table>
+
+## Using an expression with LIMIT to return a subset of the rows
+
+Limit accepts any expression that evaluates to a positive integer as long as it is not referring to any external variables:
+
+Query
+
+
+```
+SELECT *
+FROM cypher('graph_name', $$
+ MATCH (n)
+ RETURN n.name
+ ORDER BY n.name
+ LIMIT toInteger(3 * rand()) + 1
+$$) as (names agtype);
+
+```
+
+Returns one to three top items.
+
+Result
+
+
+<table>
+ <thead>
+ <td><strong>names</strong>
+ </td>
+ <thead>
+ <tr>
+ <td>"A"
+ </td>
+ </tr>
+ <tr>
+ <td>"B"
+ </td>
+ </tr>
+ <tr>
+ <td>2 rows
+ </td>
+ </tr>
+</table>
diff --git a/docs/_sources/clauses/skip.md.txt b/docs/_sources/clauses/skip.md.txt
new file mode 100644
index 0000000..28413b4
--- /dev/null
+++ b/docs/_sources/clauses/skip.md.txt
@@ -0,0 +1,136 @@
+# SKIP
+
+SKIP defines from which record to start including the records in the output.
+
+## Introduction
+
+By using SKIP, the result set will get trimmed from the top. Please note that no guarantees are made on the order of the result unless the query specifies the ORDER BY clause. SKIP accepts any expression that evaluates to a positive integer.
+
+## Skip first three rows
+
+To return a subset of the result, starting from the top, use this syntax:
+
+Query
+
+
+```
+SELECT *
+FROM cypher('graph_name', $$
+ MATCH (n)
+ RETURN n.name
+ ORDER BY n.name
+ SKIP 3
+$$) as (names agtype);
+```
+
+
+The node is returned, and no property age exists on it.
+
+Result
+
+
+<table>
+ <thead>
+ <td><strong>names</strong>
+ </td>
+ <thead>
+ <tr>
+ <td>"D"
+ </td>
+ </tr>
+ <tr>
+ <td>"E"
+ </td>
+ </tr>
+ <tr>
+ <td>2 rows
+ </td>
+ </tr>
+</table>
+
+## Return middle two rows
+
+To return a subset of the result, starting from somewhere in the middle, use this syntax:
+
+Query
+
+
+```
+SELECT *
+FROM cypher('graph_name', $$
+ MATCH (n)
+ RETURN n.name
+ ORDER BY n.name
+ SKIP 1
+ LIMIT 2
+$$) as (names agtype);
+```
+
+Two vertices from the middle are returned.
+
+Result
+
+
+<table>
+ <thead>
+ <td><strong>names</strong>
+ </td>
+ <thead>
+ <tr>
+ <td>"B"
+ </td>
+ </tr>
+ <tr>
+ <td>"C"
+ </td>
+ </tr>
+ <tr>
+ <td>2 rows
+ </td>
+ </tr>
+</table>
+
+## Using an expression with SKIP to return a subset of the rows
+
+Using an expression with SKIP to return a subset of the rows
+
+Query
+
+
+```
+SELECT *
+FROM cypher('graph_name', $$
+ MATCH (n)
+ RETURN n.name
+ ORDER BY n.name
+ SKIP (3 * rand())+ 1
+$$) as (a agtype);
+```
+
+The first two vertices are skipped, and only the last three are returned in the result.
+
+Result
+
+
+<table>
+ <thead>
+ <td><strong>names</strong>
+ </td>
+ <thead>
+ <tr>
+ <td>"C"
+ </td>
+ </tr>
+ <tr>
+ <td>"D"
+ </td>
+ </tr>
+ <tr>
+ <td>"E"
+ </td>
+ </tr>
+ <tr>
+ <td>3 rows
+ </td>
+ </tr>
+</table>
diff --git a/docs/_sources/index.rst.txt b/docs/_sources/index.rst.txt
index 1e7d668..1d8b7eb 100644
--- a/docs/_sources/index.rst.txt
+++ b/docs/_sources/index.rst.txt
@@ -23,6 +23,7 @@ Apache AGE's documentation
clauses/with
clauses/return
clauses/order_by
+ clauses/skip
clauses/limit
clauses/create
clauses/set
diff --git a/docs/advanced/advanced.html b/docs/advanced/advanced.html
index f9fba4a..33e76dc 100644
--- a/docs/advanced/advanced.html
+++ b/docs/advanced/advanced.html
@@ -110,6 +110,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/advanced/advanced_overview.html b/docs/advanced/advanced_overview.html
index 6be98a3..a047ef7 100644
--- a/docs/advanced/advanced_overview.html
+++ b/docs/advanced/advanced_overview.html
@@ -110,6 +110,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/advanced/plpgsql.html b/docs/advanced/plpgsql.html
index 331c6c4..7813392 100644
--- a/docs/advanced/plpgsql.html
+++ b/docs/advanced/plpgsql.html
@@ -109,6 +109,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/advanced/prepared_statements.html b/docs/advanced/prepared_statements.html
index 5109bd4..65bd379 100644
--- a/docs/advanced/prepared_statements.html
+++ b/docs/advanced/prepared_statements.html
@@ -110,6 +110,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/clauses/create.html b/docs/clauses/create.html
index fb32945..6d44a5b 100644
--- a/docs/clauses/create.html
+++ b/docs/clauses/create.html
@@ -110,6 +110,7 @@
<li class="toctree-l1"><a class="reference internal" href="with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="limit.html">LIMIT</a></li>
<li class="toctree-l1 current"><a class="current reference internal" href="#">CREATE</a><ul>
<li class="toctree-l2"><a class="reference internal" href="#terminal-create-clauses">Terminal CREATE clauses</a></li>
diff --git a/docs/clauses/delete.html b/docs/clauses/delete.html
index 0d4f124..98c6ca5 100644
--- a/docs/clauses/delete.html
+++ b/docs/clauses/delete.html
@@ -110,6 +110,7 @@
<li class="toctree-l1"><a class="reference internal" href="with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="set.html">SET</a></li>
diff --git a/docs/clauses/limit.html b/docs/clauses/limit.html
index b6ee768..56874cf 100644
--- a/docs/clauses/limit.html
+++ b/docs/clauses/limit.html
@@ -45,7 +45,7 @@
<link rel="index" title="Index" href="../genindex.html" />
<link rel="search" title="Search" href="../search.html" />
<link rel="next" title="CREATE" href="create.html" />
- <link rel="prev" title="ORDER BY" href="order_by.html" />
+ <link rel="prev" title="SKIP" href="skip.html" />
</head>
<body class="wy-body-for-nav">
@@ -110,9 +110,11 @@
<li class="toctree-l1"><a class="reference internal" href="with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="skip.html">SKIP</a></li>
<li class="toctree-l1 current"><a class="current reference internal" href="#">LIMIT</a><ul>
<li class="toctree-l2"><a class="reference internal" href="#introduction">Introduction</a></li>
<li class="toctree-l2"><a class="reference internal" href="#return-a-subset-of-the-rows">Return a subset of the rows</a></li>
+<li class="toctree-l2"><a class="reference internal" href="#using-an-expression-with-limit-to-return-a-subset-of-the-rows">Using an expression with LIMIT to return a subset of the rows</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="create.html">CREATE</a></li>
@@ -253,6 +255,41 @@ $$) as (names agtype);
</tr>
</table>
</div>
+<div class="section" id="using-an-expression-with-limit-to-return-a-subset-of-the-rows">
+<h2>Using an expression with LIMIT to return a subset of the rows<a class="headerlink" href="#using-an-expression-with-limit-to-return-a-subset-of-the-rows" title="Permalink to this headline">¶</a></h2>
+<p>Limit accepts any expression that evaluates to a positive integer as long as it is not referring to any external variables:</p>
+<p>Query</p>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>SELECT *
+FROM cypher('graph_name', $$
+ MATCH (n)
+ RETURN n.name
+ ORDER BY n.name
+ LIMIT toInteger(3 * rand()) + 1
+$$) as (names agtype);
+
+</pre></div>
+</div>
+<p>Returns one to three top items.</p>
+<p>Result</p>
+<table>
+ <thead>
+ <td><strong>names</strong>
+ </td>
+ <thead>
+ <tr>
+ <td>"A"
+ </td>
+ </tr>
+ <tr>
+ <td>"B"
+ </td>
+ </tr>
+ <tr>
+ <td>2 rows
+ </td>
+ </tr>
+</table>
+</div>
</div>
@@ -262,7 +299,7 @@ $$) as (names agtype);
<footer>
<div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
<a href="create.html" class="btn btn-neutral float-right" title="CREATE" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right" aria-hidden="true"></span></a>
- <a href="order_by.html" class="btn btn-neutral float-left" title="ORDER BY" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left" aria-hidden="true"></span> Previous</a>
+ <a href="skip.html" class="btn btn-neutral float-left" title="SKIP" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left" aria-hidden="true"></span> Previous</a>
</div>
<hr/>
diff --git a/docs/clauses/match.html b/docs/clauses/match.html
index d4557f5..ccb14ec 100644
--- a/docs/clauses/match.html
+++ b/docs/clauses/match.html
@@ -127,6 +127,7 @@
<li class="toctree-l1"><a class="reference internal" href="with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="set.html">SET</a></li>
diff --git a/docs/clauses/order_by.html b/docs/clauses/order_by.html
index e2ed714..dc5aad6 100644
--- a/docs/clauses/order_by.html
+++ b/docs/clauses/order_by.html
@@ -44,7 +44,7 @@
<link rel="index" title="Index" href="../genindex.html" />
<link rel="search" title="Search" href="../search.html" />
- <link rel="next" title="LIMIT" href="limit.html" />
+ <link rel="next" title="SKIP" href="skip.html" />
<link rel="prev" title="RETURN" href="return.html" />
</head>
@@ -117,6 +117,7 @@
<li class="toctree-l2"><a class="reference internal" href="#ordering-null">Ordering null</a></li>
</ul>
</li>
+<li class="toctree-l1"><a class="reference internal" href="skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="set.html">SET</a></li>
@@ -421,7 +422,7 @@ $$) as (name agtype, age agtype, height agtype);
</div>
<footer>
<div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
- <a href="limit.html" class="btn btn-neutral float-right" title="LIMIT" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right" aria-hidden="true"></span></a>
+ <a href="skip.html" class="btn btn-neutral float-right" title="SKIP" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right" aria-hidden="true"></span></a>
<a href="return.html" class="btn btn-neutral float-left" title="RETURN" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left" aria-hidden="true"></span> Previous</a>
</div>
diff --git a/docs/clauses/remove.html b/docs/clauses/remove.html
index cf5eae8..19b669a 100644
--- a/docs/clauses/remove.html
+++ b/docs/clauses/remove.html
@@ -110,6 +110,7 @@
<li class="toctree-l1"><a class="reference internal" href="with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="set.html">SET</a></li>
diff --git a/docs/clauses/return.html b/docs/clauses/return.html
index 4a94abd..8bf83c0 100644
--- a/docs/clauses/return.html
+++ b/docs/clauses/return.html
@@ -121,6 +121,7 @@
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="set.html">SET</a></li>
diff --git a/docs/clauses/set.html b/docs/clauses/set.html
index 8b7d005..926ac8d 100644
--- a/docs/clauses/set.html
+++ b/docs/clauses/set.html
@@ -110,6 +110,7 @@
<li class="toctree-l1"><a class="reference internal" href="with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="create.html">CREATE</a></li>
<li class="toctree-l1 current"><a class="current reference internal" href="#">SET</a><ul>
diff --git a/docs/clauses/limit.html b/docs/clauses/skip.html
similarity index 73%
copy from docs/clauses/limit.html
copy to docs/clauses/skip.html
index b6ee768..3eca858 100644
--- a/docs/clauses/limit.html
+++ b/docs/clauses/skip.html
@@ -7,7 +7,7 @@
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
- <title>LIMIT — Apache AGE master documentation</title>
+ <title>SKIP — Apache AGE master documentation</title>
@@ -44,7 +44,7 @@
<link rel="index" title="Index" href="../genindex.html" />
<link rel="search" title="Search" href="../search.html" />
- <link rel="next" title="CREATE" href="create.html" />
+ <link rel="next" title="LIMIT" href="limit.html" />
<link rel="prev" title="ORDER BY" href="order_by.html" />
</head>
@@ -110,11 +110,14 @@
<li class="toctree-l1"><a class="reference internal" href="with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="order_by.html">ORDER BY</a></li>
-<li class="toctree-l1 current"><a class="current reference internal" href="#">LIMIT</a><ul>
+<li class="toctree-l1 current"><a class="current reference internal" href="#">SKIP</a><ul>
<li class="toctree-l2"><a class="reference internal" href="#introduction">Introduction</a></li>
-<li class="toctree-l2"><a class="reference internal" href="#return-a-subset-of-the-rows">Return a subset of the rows</a></li>
+<li class="toctree-l2"><a class="reference internal" href="#skip-first-three-rows">Skip first three rows</a></li>
+<li class="toctree-l2"><a class="reference internal" href="#return-middle-two-rows">Return middle two rows</a></li>
+<li class="toctree-l2"><a class="reference internal" href="#using-an-expression-with-skip-to-return-a-subset-of-the-rows">Using an expression with SKIP to return a subset of the rows</a></li>
</ul>
</li>
+<li class="toctree-l1"><a class="reference internal" href="limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="set.html">SET</a></li>
<li class="toctree-l1"><a class="reference internal" href="remove.html">REMOVE</a></li>
@@ -188,14 +191,14 @@
<li><a href="../index.html" class="icon icon-home"></a> »</li>
- <li>LIMIT</li>
+ <li>SKIP</li>
<li class="wy-breadcrumbs-aside">
- <a href="https://github.com/pdpotter/age_docs/blob/master/docs/clauses/limit.md" class="fa fa-github"> Edit on GitHub</a>
+ <a href="https://github.com/pdpotter/age_docs/blob/master/docs/clauses/skip.md" class="fa fa-github"> Edit on GitHub</a>
@@ -209,22 +212,23 @@
<div role="main" class="document" itemscope="itemscope" itemtype="http://schema.org/Article">
<div itemprop="articleBody">
- <div class="tex2jax_ignore mathjax_ignore section" id="limit">
-<h1>LIMIT<a class="headerlink" href="#limit" title="Permalink to this headline">¶</a></h1>
-<p>LIMIT constrains the number of records in the output.</p>
+ <div class="tex2jax_ignore mathjax_ignore section" id="skip">
+<h1>SKIP<a class="headerlink" href="#skip" title="Permalink to this headline">¶</a></h1>
+<p>SKIP defines from which record to start including the records in the output.</p>
<div class="section" id="introduction">
<h2>Introduction<a class="headerlink" href="#introduction" title="Permalink to this headline">¶</a></h2>
-<p>LIMIT accepts any expression that evaluates to a positive integer.</p>
+<p>By using SKIP, the result set will get trimmed from the top. Please note that no guarantees are made on the order of the result unless the query specifies the ORDER BY clause. SKIP accepts any expression that evaluates to a positive integer.</p>
</div>
-<div class="section" id="return-a-subset-of-the-rows">
-<h2>Return a subset of the rows<a class="headerlink" href="#return-a-subset-of-the-rows" title="Permalink to this headline">¶</a></h2>
+<div class="section" id="skip-first-three-rows">
+<h2>Skip first three rows<a class="headerlink" href="#skip-first-three-rows" title="Permalink to this headline">¶</a></h2>
<p>To return a subset of the result, starting from the top, use this syntax:</p>
<p>Query</p>
-<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>SELECT *
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>SELECT *
FROM cypher('graph_name', $$
- MATCH (n)RETURN n.name
+ MATCH (n)
+ RETURN n.name
ORDER BY n.name
- LIMIT 3
+ SKIP 3
$$) as (names agtype);
</pre></div>
</div>
@@ -236,10 +240,41 @@ $$) as (names agtype);
</td>
<thead>
<tr>
- <td>"A"
+ <td>"D"
</td>
</tr>
<tr>
+ <td>"E"
+ </td>
+ </tr>
+ <tr>
+ <td>2 rows
+ </td>
+ </tr>
+</table>
+</div>
+<div class="section" id="return-middle-two-rows">
+<h2>Return middle two rows<a class="headerlink" href="#return-middle-two-rows" title="Permalink to this headline">¶</a></h2>
+<p>To return a subset of the result, starting from somewhere in the middle, use this syntax:</p>
+<p>Query</p>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>SELECT *
+FROM cypher('graph_name', $$
+ MATCH (n)
+ RETURN n.name
+ ORDER BY n.name
+ SKIP 1
+ LIMIT 2
+$$) as (names agtype);
+</pre></div>
+</div>
+<p>Two vertices from the middle are returned.</p>
+<p>Result</p>
+<table>
+ <thead>
+ <td><strong>names</strong>
+ </td>
+ <thead>
+ <tr>
<td>"B"
</td>
</tr>
@@ -248,6 +283,44 @@ $$) as (names agtype);
</td>
</tr>
<tr>
+ <td>2 rows
+ </td>
+ </tr>
+</table>
+</div>
+<div class="section" id="using-an-expression-with-skip-to-return-a-subset-of-the-rows">
+<h2>Using an expression with SKIP to return a subset of the rows<a class="headerlink" href="#using-an-expression-with-skip-to-return-a-subset-of-the-rows" title="Permalink to this headline">¶</a></h2>
+<p>Using an expression with SKIP to return a subset of the rows</p>
+<p>Query</p>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>SELECT *
+FROM cypher('graph_name', $$
+ MATCH (n)
+ RETURN n.name
+ ORDER BY n.name
+ SKIP (3 * rand())+ 1
+$$) as (a agtype);
+</pre></div>
+</div>
+<p>The first two vertices are skipped, and only the last three are returned in the result.</p>
+<p>Result</p>
+<table>
+ <thead>
+ <td><strong>names</strong>
+ </td>
+ <thead>
+ <tr>
+ <td>"C"
+ </td>
+ </tr>
+ <tr>
+ <td>"D"
+ </td>
+ </tr>
+ <tr>
+ <td>"E"
+ </td>
+ </tr>
+ <tr>
<td>3 rows
</td>
</tr>
@@ -261,7 +334,7 @@ $$) as (names agtype);
</div>
<footer>
<div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
- <a href="create.html" class="btn btn-neutral float-right" title="CREATE" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right" aria-hidden="true"></span></a>
+ <a href="limit.html" class="btn btn-neutral float-right" title="LIMIT" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right" aria-hidden="true"></span></a>
<a href="order_by.html" class="btn btn-neutral float-left" title="ORDER BY" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left" aria-hidden="true"></span> Previous</a>
</div>
diff --git a/docs/clauses/with.html b/docs/clauses/with.html
index e77bef5..3615354 100644
--- a/docs/clauses/with.html
+++ b/docs/clauses/with.html
@@ -116,6 +116,7 @@
</li>
<li class="toctree-l1"><a class="reference internal" href="return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="set.html">SET</a></li>
diff --git a/docs/functions/aggregate_functions.html b/docs/functions/aggregate_functions.html
index a1707d3..e0b2858 100644
--- a/docs/functions/aggregate_functions.html
+++ b/docs/functions/aggregate_functions.html
@@ -110,6 +110,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/functions/list_functions.html b/docs/functions/list_functions.html
index 466af8c..204b51e 100644
--- a/docs/functions/list_functions.html
+++ b/docs/functions/list_functions.html
@@ -110,6 +110,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/functions/logarithmic_functions.html b/docs/functions/logarithmic_functions.html
index dc30142..8fc92f2 100644
--- a/docs/functions/logarithmic_functions.html
+++ b/docs/functions/logarithmic_functions.html
@@ -110,6 +110,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/functions/numeric_functions.html b/docs/functions/numeric_functions.html
index cc3df10..966868f 100644
--- a/docs/functions/numeric_functions.html
+++ b/docs/functions/numeric_functions.html
@@ -110,6 +110,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/functions/predicate_functions.html b/docs/functions/predicate_functions.html
index 96c6c48..453376e 100644
--- a/docs/functions/predicate_functions.html
+++ b/docs/functions/predicate_functions.html
@@ -110,6 +110,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/functions/scalar_functions.html b/docs/functions/scalar_functions.html
index a62f796..c63be1a 100644
--- a/docs/functions/scalar_functions.html
+++ b/docs/functions/scalar_functions.html
@@ -110,6 +110,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/functions/string_functions.html b/docs/functions/string_functions.html
index 5bb7bb7..2fbce4d 100644
--- a/docs/functions/string_functions.html
+++ b/docs/functions/string_functions.html
@@ -110,6 +110,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/functions/trigonometric_functions.html b/docs/functions/trigonometric_functions.html
index 6bb584a..b0d79d1 100644
--- a/docs/functions/trigonometric_functions.html
+++ b/docs/functions/trigonometric_functions.html
@@ -110,6 +110,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/functions/user_functions.html b/docs/functions/user_functions.html
index d7253ab..c65275e 100644
--- a/docs/functions/user_functions.html
+++ b/docs/functions/user_functions.html
@@ -110,6 +110,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/genindex.html b/docs/genindex.html
index a136726..44927e0 100644
--- a/docs/genindex.html
+++ b/docs/genindex.html
@@ -108,6 +108,7 @@
<li class="toctree-l1"><a class="reference internal" href="clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/set.html">SET</a></li>
diff --git a/docs/index.html b/docs/index.html
index cda5988..b3d3f29 100644
--- a/docs/index.html
+++ b/docs/index.html
@@ -109,6 +109,7 @@
<li class="toctree-l1"><a class="reference internal" href="clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/set.html">SET</a></li>
@@ -226,6 +227,7 @@
<li class="toctree-l1"><a class="reference internal" href="clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/set.html">SET</a></li>
diff --git a/docs/intro/aggregation.html b/docs/intro/aggregation.html
index d409ed0..d1bce03 100644
--- a/docs/intro/aggregation.html
+++ b/docs/intro/aggregation.html
@@ -110,6 +110,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/intro/comparability.html b/docs/intro/comparability.html
index 4df2a4d..d091776 100644
--- a/docs/intro/comparability.html
+++ b/docs/intro/comparability.html
@@ -124,6 +124,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/intro/cypher.html b/docs/intro/cypher.html
index 12e1dbc..c860092 100644
--- a/docs/intro/cypher.html
+++ b/docs/intro/cypher.html
@@ -115,6 +115,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/intro/graphs.html b/docs/intro/graphs.html
index 4b46a9e..a463b36 100644
--- a/docs/intro/graphs.html
+++ b/docs/intro/graphs.html
@@ -121,6 +121,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/intro/overview.html b/docs/intro/overview.html
index d062f53..c2f209f 100644
--- a/docs/intro/overview.html
+++ b/docs/intro/overview.html
@@ -110,6 +110,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/intro/precedence.html b/docs/intro/precedence.html
index ca64fa5..d0ce9d0 100644
--- a/docs/intro/precedence.html
+++ b/docs/intro/precedence.html
@@ -110,6 +110,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/intro/setup.html b/docs/intro/setup.html
index a2fa743..725d75b 100644
--- a/docs/intro/setup.html
+++ b/docs/intro/setup.html
@@ -129,6 +129,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/intro/types.html b/docs/intro/types.html
index 6b42651..f70acbb 100644
--- a/docs/intro/types.html
+++ b/docs/intro/types.html
@@ -170,6 +170,7 @@
<li class="toctree-l1"><a class="reference internal" href="../clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="../clauses/set.html">SET</a></li>
diff --git a/docs/objects.inv b/docs/objects.inv
index 3bd7cdb..ce2142c 100644
--- a/docs/objects.inv
+++ b/docs/objects.inv
@@ -2,7 +2,4 @@
# Project: Apache AGE
# Version:
# The remainder of this file is compressed using zlib.
-xڍU�r�0��z���^{s �x&� ���SF�
@DN��5�z}�.҂��!7��[k�J<;�2�l�i��;f*e_?'? l!�*��J��@4Q<�#裀�wsz��ЯS\%�ܼ�`q�Z�E�?>ܲ��L�P��h���j�r �ք�: �%�=�D����E��aޘ�V��e�� $�M����6 ��(�
y �-��u�;
-n�C���[&��ޡt�y߄L G�jw�ط��UC�_3d�����x`��.æ��L���7�a/�O-x6�� ��&z�N͂繆 ?�s�
��
-}�D��d��ع𱆾-b�@�s��)D:��R��
-V)��|��̧�{8��s���-��D0ߤ\r=~�����p�բ�gc�T��`,2�*U�����I�d���l_������E�x)�\�C)� ~� �� ۨ��u��N2�7P,+� �-�㿿�����r�@��j��^;b��3r2��OU�:� )l3M�t��O,~��_m�[�K�e�R��%��Uk��kZ�������k j�
�RojJ�5�f��q�r��d��c����$>��ߟO Y+ܻU� @"(/㺚8�F�]��6��`z ��,q� �,�� ���cV1���PY�V�EGУ�V t�m����
pM�lo�X�M�oy�?M�v�
\ No newline at end of file
+xڍU�r�0��z���^{s �x� �!���Q`�5�H�)��F_�O�EZ05�&k-Z�g^��-8-����L�����ǽ-$[%1[I^�&��:�>x}3�W��;�u��d�� !�[+����kvQ���4�
�X�Xn��Қp�T��7D����R�q�H5 6�3Ԫm�L�ޔ����3�t _����!�#��z}�NzG�m�9 � 7�du�;��@����[m��-��j(�k����m|s�- �l�˰�e:S��M�m@�� �c �OQň���z��_�
6�Ž��:����C��y�!��뱡�M�\���� �R;>��Q@, �r�q?�HgsCR�?R�*e]���0���[�qL3����a?Ϟ曔K���OUt� ��Z��l쉊b �E&W�*������"ɐ ��Q���X� c<��О�r(E��/$��6�C�u�.����
ˊ�{`�����?���noh7Ph�Z���(䄜 $�SU��ϟ���&�h�����ܯ��K�K�e�R��%� �Uk�=�kZ���
�����k�k�
�P/vJ�5��f��q�r��d=�c���$���ߟ� Y+ܻU� @"(�8�F�]��6��`z:��,q�3�,�� ���cV1���PY�V�YG��V t�m��=��
pMoro�X�M�ox�?BW�L
\ No newline at end of file
diff --git a/docs/search.html b/docs/search.html
index fdb57db..39ebc49 100644
--- a/docs/search.html
+++ b/docs/search.html
@@ -111,6 +111,7 @@
<li class="toctree-l1"><a class="reference internal" href="clauses/with.html">WITH</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/return.html">RETURN</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/order_by.html">ORDER BY</a></li>
+<li class="toctree-l1"><a class="reference internal" href="clauses/skip.html">SKIP</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/limit.html">LIMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/create.html">CREATE</a></li>
<li class="toctree-l1"><a class="reference internal" href="clauses/set.html">SET</a></li>
diff --git a/docs/searchindex.js b/docs/searchindex.js
index 49ae595..081c23c 100644
--- a/docs/searchindex.js
+++ b/docs/searchindex.js
@@ -1 +1 @@
-Search.setIndex({docnames:["advanced/advanced","advanced/advanced_overview","advanced/plpgsql","advanced/prepared_statements","clauses/create","clauses/delete","clauses/limit","clauses/match","clauses/order_by","clauses/remove","clauses/return","clauses/set","clauses/with","functions/aggregate_functions","functions/list_functions","functions/logarithmic_functions","functions/numeric_functions","functions/predicate_functions","functions/scalar_functions","functions/string_functions","func [...]
\ No newline at end of file
+Search.setIndex({docnames:["advanced/advanced","advanced/advanced_overview","advanced/plpgsql","advanced/prepared_statements","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_functions","functions/string_f [...]
\ No newline at end of file
diff --git a/docs/src/docs/clauses/skip.md b/docs/src/docs/clauses/skip.md
new file mode 100644
index 0000000..28413b4
--- /dev/null
+++ b/docs/src/docs/clauses/skip.md
@@ -0,0 +1,136 @@
+# SKIP
+
+SKIP defines from which record to start including the records in the output.
+
+## Introduction
+
+By using SKIP, the result set will get trimmed from the top. Please note that no guarantees are made on the order of the result unless the query specifies the ORDER BY clause. SKIP accepts any expression that evaluates to a positive integer.
+
+## Skip first three rows
+
+To return a subset of the result, starting from the top, use this syntax:
+
+Query
+
+
+```
+SELECT *
+FROM cypher('graph_name', $$
+ MATCH (n)
+ RETURN n.name
+ ORDER BY n.name
+ SKIP 3
+$$) as (names agtype);
+```
+
+
+The node is returned, and no property age exists on it.
+
+Result
+
+
+<table>
+ <thead>
+ <td><strong>names</strong>
+ </td>
+ <thead>
+ <tr>
+ <td>"D"
+ </td>
+ </tr>
+ <tr>
+ <td>"E"
+ </td>
+ </tr>
+ <tr>
+ <td>2 rows
+ </td>
+ </tr>
+</table>
+
+## Return middle two rows
+
+To return a subset of the result, starting from somewhere in the middle, use this syntax:
+
+Query
+
+
+```
+SELECT *
+FROM cypher('graph_name', $$
+ MATCH (n)
+ RETURN n.name
+ ORDER BY n.name
+ SKIP 1
+ LIMIT 2
+$$) as (names agtype);
+```
+
+Two vertices from the middle are returned.
+
+Result
+
+
+<table>
+ <thead>
+ <td><strong>names</strong>
+ </td>
+ <thead>
+ <tr>
+ <td>"B"
+ </td>
+ </tr>
+ <tr>
+ <td>"C"
+ </td>
+ </tr>
+ <tr>
+ <td>2 rows
+ </td>
+ </tr>
+</table>
+
+## Using an expression with SKIP to return a subset of the rows
+
+Using an expression with SKIP to return a subset of the rows
+
+Query
+
+
+```
+SELECT *
+FROM cypher('graph_name', $$
+ MATCH (n)
+ RETURN n.name
+ ORDER BY n.name
+ SKIP (3 * rand())+ 1
+$$) as (a agtype);
+```
+
+The first two vertices are skipped, and only the last three are returned in the result.
+
+Result
+
+
+<table>
+ <thead>
+ <td><strong>names</strong>
+ </td>
+ <thead>
+ <tr>
+ <td>"C"
+ </td>
+ </tr>
+ <tr>
+ <td>"D"
+ </td>
+ </tr>
+ <tr>
+ <td>"E"
+ </td>
+ </tr>
+ <tr>
+ <td>3 rows
+ </td>
+ </tr>
+</table>
diff --git a/docs/src/docs/index.rst b/docs/src/docs/index.rst
index 1e7d668..1d8b7eb 100644
--- a/docs/src/docs/index.rst
+++ b/docs/src/docs/index.rst
@@ -23,6 +23,7 @@ Apache AGE's documentation
clauses/with
clauses/return
clauses/order_by
+ clauses/skip
clauses/limit
clauses/create
clauses/set