15 lines
465 B
Plaintext
15 lines
465 B
Plaintext
create or replace function methods( type ) as table (
|
|
select function_name, parameter_types
|
|
from duckdb_functions()
|
|
where upper(parameter_types[1]) = upper(type)
|
|
order by function_name
|
|
);
|
|
|
|
create or replace function functions_with_signature( ds ) as table (
|
|
with uc as (select list_transform(ds, x->upper(x)) as uc)
|
|
select function_name
|
|
from duckdb_functions(), uc
|
|
where list_transform(parameter_types, x->upper(x)) = uc
|
|
order by function_name
|
|
);
|