merchant

commit 8ac8e941587a029cab7a7fad7f94b3c79bd5755f
parent e4563c3f05c0e46096140b707296cc51fa8db994
Author: Christian Grothoff <christian@grothoff.org>
Date:   Sat, 29 Mar 2025 09:11:40 +0100

fix syntax in example

Diffstat:
M
src/backenddb/pg_statistics_examples.sql
 | 
12
++++++------

1 file changed, 6 insertions(+), 6 deletions(-)
diff --git a/src/backenddb/pg_statistics_examples.sql b/src/backenddb/pg_statistics_examples.sql
@@ -56,16 +56,16 @@ VALUES
   ('deposits'
   ,'sales (before refunds)'
   ,'amount'
-  ,generate_series (1, 10, 1) || generate_series (60, 180, 60),
-  ,array_fill (1, 10) || array_fill (5, 3)]
+  ,ARRAY(SELECT generate_series (1, 10, 1)) || ARRAY(SELECT generate_series (60, 180, 60)),
+  ,array_fill (1, ARRAY[10]) || array_fill (5, ARRAY[3])
   ),
   ('products-sold'
   ,'number of products sold'
   ,'number'
-  ,generate_series (1, 10, 1) || [60],
-  ,array_fill (1, 10) || [10]
+  ,ARRAY(SELECT generate_series (1, 10, 1)) || [60],
+  ,array_fill (1, ARRAY[10]) || [10]
   )
-ON CONFLICT DO NOTHING;  
+ON CONFLICT DO NOTHING;
 
 DROP FUNCTION IF EXISTS merchant_deposits_statistics_trigger CASCADE;
 CREATE FUNCTION merchant_deposits_statistics_trigger()
@@ -134,7 +134,7 @@ VALUES
   ,ARRAY['second'::statistic_range, 'minute', 'day', 'week', 'month', 'quarter', 'year']
   ,ARRAY[120, 120, 60, 12, 24, 8, 10] -- track last 120s, 120 minutes, 60 days, 12 weeks, 24 months, 8 quarters and 10 years
   )
-ON CONFLICT DO NOTHING;  
+ON CONFLICT DO NOTHING;
 
 DROP FUNCTION IF EXISTS merchant_products_sold_statistics_trigger CASCADE;
 CREATE FUNCTION merchant_products_sold_statistics_trigger()