Annotation: core.get_account_id_by_shipper_id

CREATE OR REPLACE FUNCTION core.get_account_id_by_shipper_id(integer)
RETURNS bigint

Information: core.get_account_id_by_shipper_id

Schema	core
Function Name	get_account_id_by_shipper_id
Arguments	integer
Owner	postgres
Result Type	bigint
Description

Implementation: core.get_account_id_by_shipper_id

CREATE OR REPLACE FUNCTION core.get_account_id_by_shipper_id(integer)
 RETURNS bigint
 LANGUAGE plpgsql
 STABLE
AS $function$
BEGIN
    RETURN
        core.shippers.account_id
    FROM
        core.shippers
    WHERE
        core.shippers.shipper_id=$1;
END
$function$