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

Run

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'
  );

Output Objects

Press the 'Run' button to evaluate the input

And now we can try it out:

Input

Run

select pig_latin("hello");

select pig_latin("hello");

Output Objects

Press the 'Run' button to evaluate the input

Prev Next