On 22 May 2019, at 6:51pm, [email protected] wrote: > Please add a note to the omitted page that many basic math functions are NOT > supported. (sqrt,mod,power,stdev,etc.)
Which ones should the documentation mention ? Can you find us a specification of SQL which includes that these functions ? I'm not talking about a SQL engine you can use, but one of the SQL standards which mentions them, so we know what SQLite leaves out. Compare SQLite with PostgreSQL: <https://www.postgresql.org/docs/current/functions-math.html> PostgreSQL lacks sqrt (though you can do it with power() or with '|/') and stdev (which you can't do). Both SQLite and PostgreSQL do modulo, using the '%' operator. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
