My use case was this. For some given input, find which of those input values do not have corresponding rows in a given table.
In other words something like this (but values seemed easier). select '1' as x union select '2' as x union select '3 as x where x not in (select id from foo); Picture the 1,2,3 as some form of input which requires further processing if we don't have rows for them. Perhaps there's a better way to do this that I'm not thinking of. On Tue, Dec 12, 2017 at 11:07 AM, Stephen Chrzanowski <pontia...@gmail.com> wrote: > Nifty... but... With no option for "where" or "order by", where would this > come in useful? > > On Tue, Dec 12, 2017 at 1:48 PM, Mark Wagner <m...@google.com> wrote: > > > Argh. Yes, I was on 3.8.2. Thanks! > > > > On Tue, Dec 12, 2017 at 10:45 AM, Richard Hipp <d...@sqlite.org> wrote: > > > > > On 12/12/17, Mark Wagner <m...@google.com> wrote: > > > > My reading of https://sqlite.org/syntax/select-core.html makes me > > think > > > > that I should be able to issue something like values('foo'); and get > a > > > row > > > > with a single column whose value is 'foo'. But I get a syntax error. > > > > > > > > Probably obvious to the right people but what am I missing? > > > > > > It probably means you are using an older version of SQLite. The > > > syntax you describe as introduced in version 3.8.3 (2014-02-03). > > > -- > > > D. Richard Hipp > > > d...@sqlite.org > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users