| commit | ce365d6b7e17860bd369216bbcf77e616faaec52 | [log] [tgz] |
|---|---|---|
| author | drh <[email protected]> | Tue Jan 21 00:19:43 2014 |
| committer | drh <[email protected]> | Tue Jan 21 00:19:43 2014 |
| tree | 63b56682392decc37e6649cf57891ef7c826a65b | |
| parent | a4ff825095456e0fe12dd4d9c848043fd6b91697 [diff] |
Add support for the LEVEL pseudo-column in the recursive part of a common table expression. LEVEL has the value of 1 on the first iteration and successively larger integer values of subsequent iterations. It cannot have a table qualifier. Actual columns named "level" can still be accessed by including the table name qualifier. FossilOrigin-Name: cc1cb3217800ff666a00bf4f544a5a477589bc1b