aboutsummaryrefslogtreecommitdiff
path: root/challenge-215/luca-ferrari/postgresql/ch-2.sql
blob: e92b6c4a449e4def76443a2305f2fb8fa976965b (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
44
45
46
--
-- Perl Weekly Challenge 215
-- Task 2
--
-- See <https://perlweeklychallenge.org/blog/perl-weekly-challenge-215/>
--

CREATE SCHEMA IF NOT EXISTS pwc215;

CREATE OR REPLACE FUNCTION
pwc215.task2_plpgsql( c int, digits int[] )
RETURNS boolean
AS $CODE$
DECLARE
	done boolean;
	i    int;
BEGIN
	i := 2;
	WHILE c > 0 LOOP
	      done := false;

	     WHILE i < array_length( digits, 1 )  LOOP
	     	 IF digits[ i ] = 0 AND digits[ i - 1 ] = 0 AND  digits[ i + 1 ] = 0 THEN
		    digits[ i ] := 1;
		    done := true;
		    c := c - 1;
		    EXIT;
		 END IF;

		 i := i + 1;
	     END LOOP;


	     IF NOT done THEN
	     	EXIT;
	     END IF;
	END LOOP;

	IF c = 0 THEN
	   RETURN true;
	ELSE
	   RETURN false;
	END IF;
END
$CODE$
LANGUAGE plpgsql;