Here's where I let my pedantic side out to play. The documentation for the round() function on the SQLite website at http://www.sqlite.org/lang_corefunc.html says:
"The round(X,Y) function returns a string representation of the floating-point value X rounded to Y digits to the right of the decimal point. If the Y argument is omitted, the X value is truncated to an integer." However, if you actually say execute this SQL: select typeof(round(1.1)); You get real as a result, not text. Looking at roundFunc()'s source code in sqlite3.c (from func.c) it indeed calls sqlite3_result_double(), not sqlite3_result_text(). The "Using SQLite" book, I notice gets it right, however. Best, Peter _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
