User-Defined Functions

Subtopics

EdgeQL Tutorial

EdgeDB allows users to create their own custom functions using EdgeQL. Currently only non-aggregate functions (without any SET OF parameters) can be created by the user. Let's create a simple function that converts a word into "pig Latin":

Input

CREATE FUNCTION pig_latin(val: str) -> str
    USING (
        SELECT val[1:] ++ val[0] ++ 'ay'
    );

CREATE FUNCTION pig_latin(val: str) -> str
    USING (
        SELECT val[1:] ++ val[0] ++ 'ay'
    );

Run

Output

Press the 'Run' button to evaluate the input

And now we can try it out:

Input

SELECT pig_latin("hello");

SELECT pig_latin("hello");

Run

Output

Press the 'Run' button to evaluate the input

Prev Next