Re: [sqlite] Recursive aggregate query?

2017-11-28 Thread nomad
On Tue Nov 28, 2017 at 10:13:56AM +0100, no...@null.net wrote: > I don't understand the error message generated by the following > schema/query: > > CREATE TABLE x( > id integer > ); > ... > > WITH > x > AS Woops - I just realized the CTE uses a name already

[sqlite] Recursive aggregate query?

2017-11-28 Thread nomad
I don't understand the error message generated by the following schema/query: CREATE TABLE x( id integer ); CREATE TABLE y( id integer ); CREATE TABLE y_sequence ( seq INTEGER PRIMARY KEY AUTOINCREMENT ); WITH x AS