aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorFlorian Dold <florian@dold.me>2024-07-01 00:40:55 +0200
committerFlorian Dold <florian@dold.me>2024-07-01 00:40:55 +0200
commitfefa93812b15fd03ddf683219fabfe6d4e4e9244 (patch)
treec62f8cbf67e44d5921833a33780c00b023da0523
parent3b48022af13e17004c693f429636b87b1cc57e94 (diff)
more SQL fixesv0.11.9-dev.3
-rw-r--r--src/backenddb/pg_lookup_all_products.c1
1 files changed, 1 insertions, 0 deletions
diff --git a/src/backenddb/pg_lookup_all_products.c b/src/backenddb/pg_lookup_all_products.c
index 2f3074cf..b2dbfe88 100644
--- a/src/backenddb/pg_lookup_all_products.c
+++ b/src/backenddb/pg_lookup_all_products.c
@@ -169,6 +169,7 @@ TMH_PG_lookup_all_products (void *cls,
",minimum_age"
",product_id"
",product_serial"
+ ",t.category_array AS categories"
" FROM merchant_inventory minv"
" JOIN merchant_instances inst"
" USING (merchant_serial)"