On 09/09/2016 12:06 PM, Keith Medcalf wrote:
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)
Two calls.
Dan.
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
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users