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> |
︙ | ︙ |