-- -- ec_order_amount_owed/1 -- create or replace function ec_order_amount_owed( integer ) returns numeric as $$ DECLARE v_order_id alias for $1; pre_gc_amount_owed numeric; gc_amount numeric; BEGIN pre_gc_amount_owed := ec_total_price(v_order_id) + ec_total_shipping(v_order_id) + ec_total_tax(v_order_id); gc_amount := ec_order_gift_cert_amount(v_order_id); RETURN pre_gc_amount_owed - gc_amount; END;$$ language plpgsql;