Re: How to group this?
Simon Slavin <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
On 10 Feb 2020, at 10:41pm, Wolfgang Enzinger <[email protected]> wrote: > Am Mon, 10 Feb 2020 01:42:14 +0000 schrieb Simon Slavin: > >> On 10 Feb 2020, at 1:25am, [email protected] wrote: >> >> create two VIEWs, [...]. Index both VIEWs on (id, date), > > I don't think that creating an index on a view actually works, does it? You're right. What was I thinking ? Maybe I've used another implementation of SQL that it does work on. Thanks for picking me up on it. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users