link
psql/create-function

Create Function

Create a new PostgreSQL function

function
create

Command

CREATE FUNCTION functionname(arguments) RETURNS return_type AS $$ BEGIN ... END; $$ LANGUAGE plpgsql;

Examples

Create function to add two numbers

CREATE FUNCTION add_two_numbers(a int, b int) RETURNS int AS $$ BEGIN RETURN a + b; END; $$ LANGUAGE plpgsql;