Re: [sqlite] listing registered SQL functions (aggregate or scalar)

2009-04-30 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 ddevienne wrote: How does one get this list? There is no public API. If you use the amalgamation then you can add code to dig it out of the SQLite internals (a hash table amongst other things). Look for functionSearch and sqlite3FindFunction Or

[sqlite] listing registered SQL functions (aggregate or scalar)

2009-04-29 Thread ddevienne
I can't find a way to list registered functions (the built-in ones and the ones added programmatically) via an API call nor via a built-in table like there is for tables in sqlite_master, which I could query. How does one get this list? Or asked differently, how would a user know which SQL

Re: [sqlite] listing registered SQL functions (aggregate or scalar)

2009-04-29 Thread Dennis Cote
ddevienne wrote: I can't find a way to list registered functions (the built-in ones and the ones added programmatically) via an API call nor via a built-in table like there is for tables in sqlite_master, which I could query. How does one get this list? Or asked differently, how would a user