Declaring functions
Define a function for counting reviews given a user name:
Copy
create function review_count(name: str) -> int64
using (
with module default
select count(
(
select Review
filter .author.name = name
)
)
)Drop a user-defined function:
Copy
drop function review_count(name: str);Define and use polymorphic function:
Copy
db> ...
create function make_name(name: str) -> str
using ('my_name_' ++ name);CREATE FUNCTION
Copy
db> ...
create function make_name(name: int64) -> str
using ('my_name_' ++ <str>name);CREATE FUNCTION
Copy
q>
select make_name('Alice');{'my_name_Alice'}Copy
q>
select make_name(42);{'my_name_42'}