On 26 Dec 2013, at 7:23pm, big stone <stonebi...@gmail.com> wrote: > '1' CTE can be replaced by the creation of 'N' temporary views (or > tables), and their deletion after the CTE request.
Just a quick clarification that a VIEW does not greatly increase the amount of data stored in a database. The thing that is saved when you create a VIEW is the SELECT command. No data is copied out of tables. When the VIEW is used in a SELECT the SQLite engine reconstructs the stored SELECT command, then optimizes the entire command taking into account things the VIEWs have in common with the rest of the SELECT. > I whish to have CTE in SQLite for the simplification it brings. Sorry, you're unlikely to get the specific CTE grammar you've found elsewhere in SQLite. It seems to do the same job using existing features. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users