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: |
96a13a1c676488cefb6dc9c848b8e967 |
| 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
Changes to pages/series.in.
1 2 3 4 5 6 7 |
<title>The generate_series Table-Valued Function</title>
<tcl>hd_keywords series {generate_series}</tcl>
<table_of_contents>
<h1>Overview</h1>
| | | | | > > > > > | | 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>
|
| ︙ | ︙ |