summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--worker.js2
1 files changed, 1 insertions, 1 deletions
diff --git a/worker.js b/worker.js
index 9a5ce47..f3995a6 100644
--- a/worker.js
+++ b/worker.js
@@ -92,7 +92,7 @@ amqp.connect(RABBITMQ_URI).then(async (rabbit) => {
const pad = (i) => i.toString().padStart(3, "0");
if (doCreate) { // insert
return active_items.map((i) =>
- `sum(column_get(${tableName}.item_uses, '${i}' as int)) ` +
+ `sum(coalesce(column_get(${tableName}.item_uses, '${i}' as int), 0)) ` +
`as item_${pad(i)}_use`
).join(",\n");
} else {