Declaring functions​

Define a function for counting reviews given a user name:

create function review_count(name: str) -> int64
using (
    with module default
    select count(
        (
            select Review
            filter .author.name = name
        )
    )
)

Drop a user-defined function:

drop function review_count(name: str);

Define and use polymorphic function:

create function make_name(name: str) -> str
using ('my_name_' ++ name);

CREATE FUNCTION

create function make_name(name: int64) -> str
using ('my_name_' ++ <str>name);

CREATE FUNCTION

select make_name('Alice');

{'my_name_Alice'}

select make_name(42);

{'my_name_42'}

︙