aboutsummaryrefslogtreecommitdiff
path: root/challenge-204/luca-ferrari/postgresql/ch-1.sql
blob: 98b6698450e1b4d0db813df879fb0c7f188cb659 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
--
-- Perl Weekly Challenge 204
-- Task 1
--
-- See <https://perlweeklychallenge.org/blog/perl-weekly-challenge-204/>
--

CREATE SCHEMA IF NOT EXISTS pwc204;

CREATE OR REPLACE FUNCTION
pwc204.task1_plpgsql( l int[] )
RETURNS int
AS $CODE$
DECLARE
   monotonic_mode bool;
   i int;
BEGIN

	FOR i IN 2 .. array_length( l, 1 )  LOOP
	    IF l[ i ] = l[ i - 1 ] THEN
	       CONTINUE;
	    END IF;

	    IF monotonic_mode IS NULL THEN
	       IF l[ i ] > l[ i - 1 ] THEN
	       	  monotonic_mode := true;
	       ELSE
	         monotonic_mode := false;
	       END IF;
	    END IF;

           IF monotonic_mode AND l[ i ] < l[ i - 1 ] THEN
	      RETURN 0;
	   END IF;
           IF NOT monotonic_mode AND l[ i ] > l[ i - 1 ] THEN
	      RETURN 0;
	   END IF;
	END LOOP;

	RETURN 1;
END
$CODE$
LANGUAGE plpgsql;