-- -- ec_shipment_address_update_tr/0 -- create or replace function ec_shipment_address_update_tr( ) returns trigger as $$ declare v_address_id ec_addresses.address_id%TYPE; begin select into v_address_id shipping_address from ec_orders where order_id=new.order_id; IF new.address_id is null THEN new.address_id := v_address_id; END IF; return new; end;$$ language plpgsql;