-- -- fin_trans_ccard_update_tr/0 -- create or replace function fin_trans_ccard_update_tr( ) returns trigger as $$ declare v_creditcard_id ec_creditcards.creditcard_id%TYPE; begin IF new.order_id is not null THEN select into v_creditcard_id creditcard_id from ec_orders where order_id=new.order_id; IF new.creditcard_id is null THEN new.creditcard_id := v_creditcard_id; END IF; END IF; return new; end;$$ language plpgsql;