Documentation Source Text

Check-in [96a13a1c67]
Login

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

Overview
Comment:Correct generate_series() mistakes noted in [forum:forumpost/c2101840f1|forum post c2101840f1].
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 96a13a1c676488cefb6dc9c848b8e9675b24faf9bb728549c4d93ff277327168
User & Date: larrybr 2023-01-27 02:15:29
Context
2023-01-27
13:42
Add documentation for the sqlite3_vtab_in_first() enhancement and the new unhex() SQL function. (check-in: 4c51970d12 user: drh tags: trunk)
02:15
Correct generate_series() mistakes noted in [forum:forumpost/c2101840f1|forum post c2101840f1]. (check-in: 96a13a1c67 user: larrybr tags: trunk)
2023-01-25
10:47
Correct typos noted in Forum post f381c42ab1. (check-in: 5702963af2 user: larrybr tags: trunk)
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/series.in.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15





16
17
18
19
20
21
22
23
24
<title>The generate_series Table-Valued Function</title>
<tcl>hd_keywords series {generate_series}</tcl>

<table_of_contents>

<h1>Overview</h1>

<p>The generate_series(START,END,STEP) [table-valued function] is a
[loadable extension] included in the SQLite source tree, and compiled into
the [command-line shell].  The generate_series() table has a single
result column named "value" holding integer values
and a number of rows determined by the
parameters START, END, and STEP.  The first row of the table has
a value of START.  Subsequent rows increase by STEP up to END.






<p>Omitted parameters take on default values.  STEP defaults to 1.
END defaults to 9223372036854775807.  The START parameter is required
as of version 3.37.0 ([dateof:3.37.0]) and later and an error will
be raised if START is omitted or has a self-referential or otherwise
uncomputable value.  Older versions used a default of 0 for START.
The legacy behavior can be obtained from recent code by compiling
with -DZERO_ARGUMENT_GENERATE_SERIES.

<h2>Equivalent Recursive Common Table Expression</h2>







|

|


|
|

>
>
>
>
>

|







1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
<title>The generate_series Table-Valued Function</title>
<tcl>hd_keywords series {generate_series}</tcl>

<table_of_contents>

<h1>Overview</h1>

<p>The generate_series(START,STOP,STEP) [table-valued function] is a
[loadable extension] included in the SQLite source tree, and compiled into
the [command-line shell].  The generate_series() table has one visible
result column named "value" holding integer values
and a number of rows determined by the
parameters START, STOP, and STEP.  The first row of the table has
a value of START.  Subsequent rows increase by STEP up to STOP.

<p>The generate_series() table has additional, hidden columns
named "start", "stop", and "step" whose values are the effective
values of START, STOP and STEP as provided or defaulted.
It also has a rowid, accessible by its usual names.

<p>Omitted parameters take on default values.  STEP defaults to 1.
STOP defaults to 4294967295.  The START parameter is required
as of version 3.37.0 ([dateof:3.37.0]) and later and an error will
be raised if START is omitted or has a self-referential or otherwise
uncomputable value.  Older versions used a default of 0 for START.
The legacy behavior can be obtained from recent code by compiling
with -DZERO_ARGUMENT_GENERATE_SERIES.

<h2>Equivalent Recursive Common Table Expression</h2>