On Thu, Sep 14, 2017 at 11:43 PM, Nico Williams <n...@cryptonector.com> wrote:
> On Thu, Sep 14, 2017 at 1:10 PM Simon Slavin <slav...@bigfraud.org> 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
