Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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")
- VALUES (albara."AlcNro",albara."AlcNri", 1, albara."AlcFacAno", trim(albara."AlcFacSerC"), albara."AlcFacNro", linea."ArtCod", descripcio, cantidad, mesura, costUnitari, costTotalProducte)
- ON CONFLICT (alc_nri, company_id, alc_lin)
- do update set "total_cost" = quantity * "unit_cost"; --quantity defined outside
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement