What about including (some of them) into the core? So that every user on every SQLite could use them without extra work?
Also that looks like you could easily shot your leg: "The files below are contributed by users and are not part of the standard SQLite package. The content of these files has not been verified. Use at your own risk." 2015-07-24 15:23 GMT+02:00 Jean Chevalier <jchevalier at gmx.net>: > Floor and Ceil can be dynamically loaded. Check last entry here: > http://www.sqlite.org/contrib > > > Today, Artem Skoretskiy wrote: > > > > Hi all, > > > > According to the documentation https://www.sqlite.org/lang_corefunc.html > > SQLite does not provide some basic math functions such as floor and ceil. > > They are pretty handy additions for "round" function that is present. > > > > For me as developer it would be great to have them in the core. I'm > almost > > confident it will take only a small fraction of time that it took to > > implement "round" function. > > > > Maybe floor and ceil are not part of SQL-92 that AFAIK you try to follow > -- > > but these functions are so common that you should still consider it. > > > > P.S. I'm aware of workaround for floor (only for positive numbers -- > > floor(N) == round(N - 0.5)) but it is only a workaround. > > > > -- > > Truly yours, > > Artem Skoretskiy > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Truly yours, Artem Skoretskiy
