User-Defined Functions

Subtopics

EdgeQL Tutorial

It is possible to create a function that requires certain arguments to be named-only. This approach is useful if a function has many parameters that can be omitted. Let's create a function that adds a prefix and suffix to a string:

Input

CREATE FUNCTION code_rename(
    val: str,
    NAMED ONLY prefix: str = '',
    NAMED ONLY suffix: str = ''
) -> str
    USING (
        SELECT prefix ++ val ++ suffix
    );

CREATE FUNCTION code_rename(
    val: str,
    NAMED ONLY prefix: str = '',
    NAMED ONLY suffix: str = ''
) -> str
    USING (
        SELECT prefix ++ val ++ suffix
    );

Run

Output

Press the 'Run' button to evaluate the input

And now we can try it out:

Input

SELECT code_rename("count", prefix := 'my_');

SELECT code_rename("count", prefix := 'my_');

Run

Output

Press the 'Run' button to evaluate the input

Input

SELECT code_rename("count", suffix := '_words');

SELECT code_rename("count", suffix := '_words');

Run

Output

Press the 'Run' button to evaluate the input

Prev Next