Re: [sqlite] log() in sqlite3

On Friday, 31 January, 2020 17:59, Peng Yu wrote: >How to use extension-functions.c? It means that I have to compile it? Yes. Either as a loadable extension or as core builtin functions extending the amalgamation. >How to use it with python? db.load_extension() for each connection db into

Re: [sqlite] log() in sqlite3

don't need to do the more tedious: >> a) Get original data with statement 1 >> b) Do calculations in the outside program >> c) Use the result in statement 2 >> >> >> -----Original Message- >> From: sqlite-users On >> Behalf Of Peng Yu >>

Re: [sqlite] log() in sqlite3

you don't need to do the more tedious: > a) Get original data with statement 1 > b) Do calculations in the outside program > c) Use the result in statement 2 > > > -Original Message- > From: sqlite-users On > Behalf Of Peng Yu > Sent: Friday, January 31, 2020 12

Re: [sqlite] log() in sqlite3

To: SQLite mailing list Subject: [sqlite] log() in sqlite3 Hi, I see that many math functions (like log()) are not in sqlite3. It seems that SQL standard doesn't have them. https://www.sqlite.org/lang_corefunc.html But since sqlite3 contains non-standard functions anyway. Would it be conside

[sqlite] log() in sqlite3

Hi, I see that many math functions (like log()) are not in sqlite3. It seems that SQL standard doesn't have them. https://www.sqlite.org/lang_corefunc.html But since sqlite3 contains non-standard functions anyway. Would it be considered to add those functions? Given the current version of