Annotation: core.get_shipper_name_by_shipper_id

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

Information: core.get_shipper_name_by_shipper_id

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

Implementation: core.get_shipper_name_by_shipper_id

CREATE OR REPLACE FUNCTION core.get_shipper_name_by_shipper_id(integer)
 RETURNS text
 LANGUAGE plpgsql
AS $function$
BEGIN
    RETURN
    (
        SELECT company_name
        FROM core.shippers
        WHERE shipper_id=$1
    );
END
$function$