Annotation: core.get_salesperson_name_by_salesperson_id

CREATE OR REPLACE FUNCTION core.get_salesperson_name_by_salesperson_id(integer)
RETURNS text

Information: core.get_salesperson_name_by_salesperson_id

Schema core
Function Name get_salesperson_name_by_salesperson_id
Arguments integer
Owner postgres
Result Type text
Description

Implementation: core.get_salesperson_name_by_salesperson_id

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$