On Thu, Aug 24, 2017 at 1:24 AM, Keith Medcalf <kmedc...@dessus.com> wrote:

> >On Wed, Aug 23, 2017 at 6:11 PM, Keith Medcalf <kmedc...@dessus.com>
> wrote:
> >Where's that pragma from Keith? Thanks, --DD
>
> They were added "experimentally" on July 7, 2017


Oh cool, that's great! thanks for the heads-up.


> You will note that for example the returned rows show both the builtin and
> user-defined function names,

even though one may be overriding the other in various circumstances,

and also no differentiation between scalar functions, aggregates, and no
> flags or argument numbers/types.


I hope this is added eventually, fwiw. All that info exists in the
in-memory data-model,
so there's no reason the evtable wouldn't expose it IMHO. Then again, I've
thought for years
there's no reason SQLite didn't have this pragma either, so who knows
if/when that might come :)


> They appeared in the 3.20.0 release code although turned off by default --

you need to "build your own" with the preprocessor symbol
> SQLITE_INTROSPECTION_PRAGMAS defined.
>
> The commit to trunk can be found here:
> https://www.sqlite.org/src/info/e0b6ae92adfae46f


Thanks again for the detailed info. Cheers, --DD
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to