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

Reply via email to