On Thu, Sep 14, 2017 at 11:43 PM, Nico Williams <[email protected]> wrote:
> On Thu, Sep 14, 2017 at 1:10 PM Simon Slavin <[email protected]> wrote: > > Can you not do it with WITH ? I don’t really understand how WITH works > > but it would seem to evaluate its terms just once for each iteration. > > [...] I would much prefer to be able to specify which CTEs must be > materialized, > and which may be left as internal views. That would give the user a great > deal of control. WITH x AS (<query>) MATERIALIZED ... . Can we get that? > +1 --DD _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
