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

Note that the tutorial is set to allow direct DDL commands to create functions via the create keyword. In practice, you will add functions to your schema without using create.

Now let's try the pig_latin function out:

Input

Run

select pig_latin("hello");

select pig_latin("hello");

Output Objects

Press the 'Run' button to evaluate the input

Prev Next

We use ChatGPT with additional context from our documentation to answer your questions. Not all answers will be accurate. Please join our Discord if you need more help.