On 25 Jun 2017, at 10:36, David Empson wrote: > json_patch() was added to the json1 extension in SQLite 3.18.0, but the other > functions were there in earlier versions as far back as SQLite 3.9.0.
Hi, I see... > Looking at https://sqlitestudio.pl/index.rvt?act=changelog it appears the > latest version of SQLiteStudio (3.1.1) is using SQLite 3.15.0, so that is > consistent with it not supporting json_patch(). Ok, thanks. > As for your own program, are you compiling the SQLite 3.18.0 (or later) > amalgamation and linking it directly into your program, Yes, I do this. I'm using 3.19.3 now. I found out that if you don't set SQLITE_ENABLE_JSON1 it seems some functions are available but not all... when setting SQLITE_ENABLE_JSON1 all are available. That's a bit strange IMO, but might be a problem on my end, not sure. -- Robert M. Münch, CEO M: +41 79 65 11 49 6 Saphirion AG smarter | better | faster http://www.saphirion.com http://www.nlpp.ch
signature.asc
Description: OpenPGP digital signature
_______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

