Richard, Can a single sqlite3_create_function call define a function which is both a scalar function and an aggregate function, or are two calls to create_function required, one defining the scalar and the other the aggregate version? (using the same function name)
On Thursday, 8 September, 2016 08:17, Richard Hipp said: > On 9/8/16, Stephen Chrzanowski <pontia...@gmail.com> wrote: > > > > However, the rabbit I was hoping to pull out of the hat was that the > change > > in version numbers be done automatically when I make a change in the 3rd > > party DB management tool. > > Perhaps make your application schema-version number a hash of the SQL > for the schema, like this: > > SELECT md5sum(sql) FROM ( > SELECT sql FROM sqlite_master > WHERE sql IS NOT NULL > ORDER BY sql > ); > > You will need to add the md5sum() aggregate function yourself. A > sample implementation can be found in the SQLite source tree (used for > testing) here: https://www.sqlite.org/src/artifact/bdae822f2?ln=3894-3932 > > -- > 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