Search
ctrl/
Ask AI
Light
Dark
System

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'}