CREATE OR REPLACE FUNCTION core.get_salesperson_name_by_salesperson_id(integer) RETURNS text LANGUAGE plpgsql AS $function$ BEGIN RETURN ( SELECT salesperson_name FROM core.salespersons WHERE salesperson_id=$1 ); END $function$