Petite Abeille wrote: > On Jan 24, 2014, at 2:31 PM, Richard Hipp <d...@sqlite.org> wrote: >> Please see http://www.sqlite.org/draft/lang_with.html for draft >> documentation of the new Common Table Expression implementation for SQLite >> 3.8.3. Comments, criticism, and typo-corrections are appreciated. > > (1) What is this VALUES( … ) construct? What purpose does it serves?
It's exactly the same as "SELECT …", but a little bit easier to write. (It behaves like with INSERT, but is now available in every place where a SELECT would be allowed.) > (2) What about cycles? How does one deal with them? With cycles, you probably want to use UNION instead of UNION ALL to stop at duplicate records. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users