Annotation: core.shippers_after_insert_trigger

CREATE OR REPLACE FUNCTION core.shippers_after_insert_trigger()
RETURNS trigger

Information: core.shippers_after_insert_trigger

Schema	core
Function Name	shippers_after_insert_trigger
Arguments
Owner	postgres
Result Type	trigger
Description

Implementation: core.shippers_after_insert_trigger

CREATE OR REPLACE FUNCTION core.shippers_after_insert_trigger()
 RETURNS trigger
 LANGUAGE plpgsql
AS $function$
BEGIN
    UPDATE core.shippers
    SET 
        shipper_code=core.get_shipper_code(NEW.company_name)
    WHERE core.shippers.shipper_id=NEW.shipper_id;
    
    RETURN NEW;
END
$function$