The generate_series Table-Valued Function

1.1. Equivalent Recursive Common Table Expression

1. Overview

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 .html?lang=en"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 ST

登录查看完整内容