--
-- 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;