Hello, Writing a scalar SQL function, is there a C-level way to call some other scalar SQL function? For instance, writing some specialized date_xyz(), could it be possible to prepare some arguments and call strftime()?
I see in the code that strftimeFunc() is the implementation for the predefined strftime(), and I see no huge difficulty calling it from my own function, but of course it is internal (static). Did I miss something in the API that would let me get a hand on it? Something like some 'sqlite3_call_function(...)' which would take the function name as text and let me hand it the context, count of arguments, array of them, and return me somehow a sqlite_value with the result? I think it is obvious I could build a SQL statement from within the function and execute it. But it sounds costly to involve the parser (yes, it's fast) for that, isn't it? -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om