Home > database >  Postgresql plan task
Postgresql plan task

Time:09-30

The begin.
Insert into st_ordermoney SELECT w.c _serviceid, n.c _name servicename, s.c _name standardname, w.c _standardid, sum (w.c _price + COALESCE (w.c _discount, 0) + COALESCE (w.c _coin, 0)) AS c_money FROM w_order w LEFT JOIN w_standard s ON w.c _standardid=s.c _id LEFT JOIN w_nextservice n ON w.c _serviceid=n.c _id WHERE w.c _ordertype=1 and w.c _paystatus='paid' GROUP BY w.c _serviceid, n.c _name, s.c _name, c_standardid;
commit;

Code above to define postgresql plan task, step 1, the definition of direct execution, relevant records can insert normally, but the execution plan tasks, according to plan mission success, but there is no data inside the table, don't know is what circumstance,
  • Related