Changes between Version 8 and Version 9 of AdvancedAppDevelopment

Timestamp:

09/30/25 19:46:49 (2 weeks ago)

Author:

185022

Comment:

--

AdvancedAppDevelopment

@@ -78 +78 @@
 
 {{{#!sql
-create or replace function ArticleSalesChangeOnPriceChange()
-returns table(
-    articleName varchar(128),
-    unitPrice decimal(10,2),
-    priceEffectiveDate timestamp,
+create or replace function "IND0_185022".articlesaleschangeonpricechange()
+ returns table(
+    articlename character varying,
+    unitprice numeric,
+    priceeffectivedate timestamp without time zone,
     units_sold bigint,
-    revenue decimal(10,2)
-)
-language plpgsql
-as $$
+    revenue numeric
+)
+language plpgsql
+as $function$
 begin
 return query
@@ -136 +136 @@
 order by a.art_name, sp.price_eff_date;
 end;
-$$;
+$function$;
 }}}