On 23 May 2019, at 7:57am, Thomas Kurz <sqlite.2...@t-net.ruhr> wrote:
> CREATE VIEW foo AS SELECT {if has stddev then stddev(...) else null} FROM ...
'if' in SQL language is CASE.
Near the beginning of your code, try to execute a function that contains
stddev(). Make a note of whether it compiles without errors or not. If it
compiles, then the function is available. Store this boolean somewhere and use
it later on in your code.
What you propose doing: creating a library call which works differently
depending on whether stddev() is available just leads to infinite regress. If
you create such a library call then you'll want to create another library to
tell whether /your/ library call is available.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
