postgresql create function

plpgsql-create-function.sql

-- DROP FUNCTION IF EXISTS function name;
           
CREATE FUNCTION function name (
  argument types
)
RETURNS return type
AS $$
DECLARE
  function scope variables
BEGIN
  function contents
END;

$$ LANGUAGE 'plpgsql';