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 tem
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 it
-Original Message-
>From: sqlite-users On
>Behalf Of Golding Robert
>Sent: Wednesday, 29 January, 2020 08:02
>To: sqlite-users@mailinglists.sqlite.org
>Subject: [sqlite] single table data collapse with constraints
>
>Hi,
>
>I am emailing to ask if someone could advise
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 t
4 matches
Mail list logo