From cecf189f37fcf86a24862bf40283975e73392ca9 Mon Sep 17 00:00:00 2001
From: Luca Ferrari <fluca1978@gmail.com>
Date: Mon, 12 Dec 2022 10:33:18 +0100
Subject: plpgsql fixes

---
 challenge-195/luca-ferrari/postgresql/ch-1.sql | 3 ++-
 challenge-195/luca-ferrari/postgresql/ch-2.sql | 9 +++++++++
 2 files changed, 11 insertions(+), 1 deletion(-)

diff --git a/challenge-195/luca-ferrari/postgresql/ch-1.sql b/challenge-195/luca-ferrari/postgresql/ch-1.sql
index a736df90b1..c6cbc28437 100644
--- a/challenge-195/luca-ferrari/postgresql/ch-1.sql
+++ b/challenge-195/luca-ferrari/postgresql/ch-1.sql
@@ -16,7 +16,8 @@ BEGIN
 	    SELECT count(*)
 	    INTO   freq
 	    FROM regexp_split_to_table( i::text, '' ) as n(d)
-	    GROUP BY d;
+	    GROUP BY d
+	    ORDER BY 1 DESC;
 
 	    IF freq = 1 THEN
 	       counter := counter + 1;
diff --git a/challenge-195/luca-ferrari/postgresql/ch-2.sql b/challenge-195/luca-ferrari/postgresql/ch-2.sql
index c6b8cf318a..633ffc8c4f 100644
--- a/challenge-195/luca-ferrari/postgresql/ch-2.sql
+++ b/challenge-195/luca-ferrari/postgresql/ch-2.sql
@@ -3,6 +3,15 @@
 
 CREATE SCHEMA IF NOT EXISTS pwc195;
 
+/*
+testdb=> select pwc195.task2_plpgsql( array[1,2,2,3,4,4,4,5,6,6,6,6]::int[] );
+NOTICE:  relation "nums" already exists, skipping
+ task2_plpgsql
+---------------
+             6
+
+*/
+
 CREATE OR REPLACE FUNCTION
 pwc195.task2_plpgsql( list int[] )
 RETURNS int
-- 
cgit