Skip to content

Open-source manufacturing ERP, MES and QMS. Quoting, MRP, inventory, shop floor, quality and lot/serial traceability on one Postgres schema, with a REST API and MCP server. Self-host or use Carbon Cloud.

479 B
Raw Blame
CREATE OR REPLACE FUNCTION public.sync_update_quote_exchange_rate(p_table text, p_operation text, p_new jsonb, p_old jsonb)
 RETURNS void
 LANGUAGE plpgsql
 SET search_path TO 'public', 'extensions'
AS $function$
BEGIN
  IF p_operation = 'UPDATE'
    AND (p_old->>'exchangeRate') IS DISTINCT FROM (p_new->>'exchangeRate')
  THEN
    UPDATE "quoteLinePrice"
    SET "exchangeRate" = (p_new->>'exchangeRate')::numeric
    WHERE "quoteId" = p_new->>'id';
  END IF;
END;
$function$;