q icon indicating copy to clipboard operation
q copied to clipboard

Be able to list all available user-functions

Open rahulamalkar opened this issue 7 years ago • 3 comments

Hi there, I was willing to know what all the SQL functions does 'q' supports...

rahulamalkar avatar Jul 13 '17 07:07 rahulamalkar

Looking through the code I could only find regexp and sha1 https://github.com/harelba/q/blob/6b06a7cba3426ae0c77dc6507b6d9da1fa4e11d6/bin/q#L158

njlr avatar Mar 27 '18 11:03 njlr

Hi, q automatically supports the standard sqlite3 functions (see inside https://www.sqlite.org/). In addition, I've added user-function support for regexp and sha1.

I do agree that the list of those user functions needs to be available, however listing all the available functions would mean duplicating sqlite3's documentation, and this is something that I don't think would be beneficial.

I will change this ticket description to add an option to list all user functions.

harelba avatar Mar 29 '18 14:03 harelba

Added a flag to show all user-defined-functions added by q. Will be released in the next version.

harelba avatar Sep 13 '20 13:09 harelba