Ooups ! Thanks to the awesome posts about "RPAD/LPAD", I understood that I could already create a "sqrt()" function for SQLite3 in interpreted python.
**** (example) ******* import sqlite3 db_filename = ':memory:' def mysqrt(s): """ returns sqrt(s)""" #must return a string, apparently return ("%s" %sqrt(s)) with sqlite3.connect(db_filename) as conn: conn.create_function('mysqrt', 1, mysqrt) cursor = conn.cursor() query = "select 'hello, sqrt' , mysqrt(3), 'of ', mysqrt(3)*mysqrt(3) " cursor.execute(query) for row in cursor.fetchall(): print (row) cursor.close cursor = None conn.close conn = None **** (The link that showed nicely how to play with that) ******* http://pymotw.com/2/sqlite3/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users