sql - postgresQL 更新错误

Question

CREATE TRIGGER INSERT_salesorderdetail
before insert on salesorderdetail
for each row 
UPDATE customer
set number_of_items=IFNULL(number_of_items,0)+1
where new.customerid=customer.customerid;

我有 2 个表 salesorderdetail 和 customer，每次我在 salesorderdetail 中插入一个新项目时，我都希望将我在 customer 中的列更新为 number_of_items，但由于某种原因，我在更新时遇到语法错误。

Answer 1

这可能对您有帮助:

CREATE OR REPLACE FUNCTION update_customer()
  RETURNS trigger AS
$BODY$

  -- update ur table here

        RETURN NULL;
    END; 
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION update_customer()
  OWNER TO db_name;

现在创建触发器为:

CREATE TRIGGER INSERT_salesorderdetail
before insert on salesorderdetail
for each row execute procedure update_customer();