Documentation Source Text

Check-in [9edcd33d7a]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix a markup typo in the WITH documentation.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | branch-3.32
Files: files | file ages | folders
SHA3-256: 9edcd33d7aa3264b6465ace97d12b2ab84dd70e246fa48af64646f2e8dbb7909
User & Date: drh 2020-06-10 16:04:05
Context
2020-06-13
17:39
Fix typo on the prosupport page. (check-in: 50f0077137 user: drh tags: branch-3.32)
2020-06-10
16:04
Fix a markup typo in the WITH documentation. (check-in: 9edcd33d7a user: drh tags: branch-3.32)
2020-06-06
23:36
Typo on the title of lang_expr.html (check-in: 49bc712623 user: drh tags: branch-3.32)
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/lang_with.in.

133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
<tcl>hd_fragment rcex1</tcl>
<h2>Recursive Query Examples</h2>

<p>The following query returns all integers between 1 and 1000000:

<blockquote><pre>
WITH RECURSIVE
  cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<1000000)
SELECT x FROM cnt;
</pre></blockquote>

<p>Consider how this query works.  The initial-select
runs first and returns a single row
with a single column "1".  This one row is added to the queue.  In
step 2a, that one row is extracted from the queue and added to "cnt".







|







133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
<tcl>hd_fragment rcex1</tcl>
<h2>Recursive Query Examples</h2>

<p>The following query returns all integers between 1 and 1000000:

<blockquote><pre>
WITH RECURSIVE
  cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x&lt;1000000)
SELECT x FROM cnt;
</pre></blockquote>

<p>Consider how this query works.  The initial-select
runs first and returns a single row
with a single column "1".  This one row is added to the queue.  In
step 2a, that one row is extracted from the queue and added to "cnt".