Changes between Version 5 and Version 6 of AdvancedAppDevelopment

Timestamp:

09/30/25 02:50:43 (12 months ago)

Author:

185022

Comment:

--

AdvancedAppDevelopment

@@ -249 +249 @@
 create or replace function ArticleSalesInWarehouseByQuarters()
 returns table(
-    warehouseId bigint,
+    warehouseId integer,
     warehouseAddress varchar(128),
     warehouseCity varchar(128),
@@ -256 +256 @@
     "quarter" double precision,
     totalArticlesSold bigint,
-    totalSales decimal(10,2)
+    totalSales bigint
 )
 language plpgsql
@@ -266 +266 @@
        c.city_name as warehouseCity,
        r.region_name as warehouseRegion,
-       extract(year from o.ord_date) as "year",
-       extract(quarter from o.ord_date) as "quarter",
+       extract(year from o.ord_date)::double precision as "year",
+       extract(quarter from o.ord_date)::double precision as "quarter",
        count(au.unit_id) as totalArticlesSold,
        sum(o.ord_sum) as totalSales