Re: [sqlite] single table data collapse with constraints

On Behalf Of Jean-Luc Hainaut Sent: 01 February 2020 19:01 To: SQLite mailing list Subject: Re: [sqlite] single table data collapse with constraints Hi Robert, I'm a bit late: I missed your post in the recent tsunami (of posts)! Your question relates to one of the basic primitives of temporal

Re: [sqlite] single table data collapse with constraints

Hi Robert, I'm a bit late: I missed your post in the recent tsunami (of posts)! Your question relates to one of the basic primitives of temporal databases, "coalescing". Basic but far from simple if you want to express it in pure SQL. On the contrary, the answer is much simpler if you code

Re: [sqlite] single table data collapse with constraints

t;To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] single table data collapse with constraints > >Hi, > >I am emailing to ask if someone could advise me how to create a query or >queries which will collapse some data based on a limited number of >constraints. >I am

[sqlite] single table data collapse with constraints

Hi, I am emailing to ask if someone could advise me how to create a query or queries which will collapse some data based on a limited number of constraints. I am currently attempting to complete this task using DB Browser for SQLite. I have tried to write a WITH RECLUSIVE statement as I think