Task 1 done in plpgsql

1 files changed, 18 insertions, 0 deletions

diff --git a/challenge-139/luca-ferrari/postgresql/ch-1.sql b/challenge-139/luca-ferrari/postgresql/ch-1.sql
new file mode 100644
index 0000000000..9685ec2948
--- /dev/null
+++ b/challenge-139/luca-ferrari/postgresql/ch-1.sql
@@ -0,0 +1,18 @@
+CREATE OR REPLACE FUNCTION
+  f_jort_sort( n int[] )
+  RETURNS int
+AS $CODE$
+  DECLARE
+  n_ordered int[];
+BEGIN
+  SELECT ( ARRAY( SELECT unnest( n ) ORDER BY 1 ) )
+    INTO n_ordered;
+
+  IF array_to_string( n, '|' ) = array_to_string( n_ordered, '|' ) THEN
+    RETURN 1;
+  ELSE
+    RETURN 0;
+  END IF;
+END
+  $CODE$
+  LANGUAGE plpgsql;