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


Reply via email to