jayzhan211 commented on issue #12144:
URL: https://github.com/apache/datafusion/issues/12144#issuecomment-2323576458
> We can certainly present this information as a table function (instead of,
or additionally to).
What would be the main advantage of doing so?
We could easily apply any query on the table function like
```
SELECT DISTINCT ON(function_name)
function_name,
function_type,
return_type,
parameters,
parameter_types,
description
FROM duckdb_functions()
WHERE function_type = 'scalar'
AND function_name LIKE 'b%'
ORDER BY function_name;
```
and we can get a subset of information with `select`
Unlike the syntax here, it is completely different so we need additional
syntax support. It is also not easy to select subset of information
```
SHOW FUNCTIONS [ LIKE '<pattern>' ]
[ IN
{
ACCOUNT |
CLASS <class_name> |
DATABASE |
DATABASE <database_name> |
SCHEMA |
SCHEMA <schema_name> |
<schema_name>
}
]
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
