Advertisement
Guest User

Untitled

a guest
Jan 14th, 2019
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. INSERT INTO "font"."statistics_albarans" ("alc_nro", "alc_nri", "fac_emp_doc","fac_ano", "fac_ser_cod","fac_nro", "article_code", "article_description", "units", "med", "unit_cost", "total_cost")
  2.                             VALUES (albara."AlcNro",albara."AlcNri", 1, albara."AlcFacAno", trim(albara."AlcFacSerC"), albara."AlcFacNro", linea."ArtCod", descripcio, cantidad,  mesura, costUnitari, costTotalProducte)
  3.                                 ON CONFLICT (alc_nri, company_id, alc_lin)
  4.                                 do update set "total_cost" = quantity * "unit_cost"; --quantity defined outside
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement