On Fri, Nov 30, 2018 at 3:03 PM Dominique Devienne <ddevie...@gmail.com> wrote:
> On Fri, Nov 30, 2018 at 2:44 PM Richard Hipp <d...@sqlite.org> wrote: > >> On 11/30/18, Simon Walter <si...@gikaku.com> wrote: >> > Thanks Dominique, >> > >> > Much appreciated. I can now stop pulling out my hair. I will do >> > something with sprintf. >> >> See https://www.sqlite.org/carray.html > > > Right. Any table-valued function would do too.[...] > In fact, it's probably possible right now via the > JSON1 extension, if your text value is JSON-formatted. > Yep, works fine, as expected. So that's another possibility too. Assuming you can use the JSON1 extension and it's enabled in the SQLite DDL. --DD sqlite> .header on sqlite> create table t (c, n); sqlite> insert into t values (1, 'one'), (2, 'two'), (3, 'three'); sqlite> select n from t where c in (select value from json_each('[1, 3]')); n one three sqlite> select n from t where c in (select value from json_each('[]')); sqlite> select n from t where c in (select value from json_each('[2]')); n two sqlite> > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
