On Fri Sep 15, 2017 at 09:55:40AM +0200, Dominique Devienne wrote:
> On Thu, Sep 14, 2017 at 11:43 PM, Nico Williams <n...@cryptonector.com>
> wrote:
>
> > [...] 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
I would also like to see such a feature. I don't know if the syntax
above is standard SQL. If not, I would suggest an alternative position
for the extra keyword:
WITH MATERIALIZED
x
AS
( SELECT ... )
SELECT
a
FROM
x
That fits in better with the existing RECURSIVE keyword position, looks
better to my eyes, and would make my life as the author of an SQLite
wrapper easier :-)
--
Mark Lawrence
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
