diff options
| -rw-r--r-- | challenge-206/luca-ferrari/blog-1.txt | 1 | ||||
| -rw-r--r-- | challenge-206/luca-ferrari/blog-2.txt | 1 | ||||
| -rw-r--r-- | challenge-206/luca-ferrari/blog-3.txt | 1 | ||||
| -rw-r--r-- | challenge-206/luca-ferrari/blog-4.txt | 1 | ||||
| -rw-r--r-- | challenge-206/luca-ferrari/blog-5.txt | 1 | ||||
| -rw-r--r-- | challenge-206/luca-ferrari/blog-6.txt | 1 | ||||
| -rw-r--r-- | challenge-206/luca-ferrari/postgresql/ch-1.sql | 2 | ||||
| -rw-r--r-- | challenge-206/luca-ferrari/postgresql/ch-2.sql | 4 |
8 files changed, 9 insertions, 3 deletions
diff --git a/challenge-206/luca-ferrari/blog-1.txt b/challenge-206/luca-ferrari/blog-1.txt new file mode 100644 index 0000000000..b4e5f2d251 --- /dev/null +++ b/challenge-206/luca-ferrari/blog-1.txt @@ -0,0 +1 @@ +https://fluca1978.github.io/2023/02/27/PerlWeeklyChallenge206.html#task1 diff --git a/challenge-206/luca-ferrari/blog-2.txt b/challenge-206/luca-ferrari/blog-2.txt new file mode 100644 index 0000000000..bbeb3b8149 --- /dev/null +++ b/challenge-206/luca-ferrari/blog-2.txt @@ -0,0 +1 @@ +https://fluca1978.github.io/2023/02/27/PerlWeeklyChallenge206.html#task2 diff --git a/challenge-206/luca-ferrari/blog-3.txt b/challenge-206/luca-ferrari/blog-3.txt new file mode 100644 index 0000000000..ba8342161d --- /dev/null +++ b/challenge-206/luca-ferrari/blog-3.txt @@ -0,0 +1 @@ +https://fluca1978.github.io/2023/02/27/PerlWeeklyChallenge206.html#task1plperl diff --git a/challenge-206/luca-ferrari/blog-4.txt b/challenge-206/luca-ferrari/blog-4.txt new file mode 100644 index 0000000000..072ce91cbe --- /dev/null +++ b/challenge-206/luca-ferrari/blog-4.txt @@ -0,0 +1 @@ +https://fluca1978.github.io/2023/02/27/PerlWeeklyChallenge206.html#task2plperl diff --git a/challenge-206/luca-ferrari/blog-5.txt b/challenge-206/luca-ferrari/blog-5.txt new file mode 100644 index 0000000000..d444dccdd3 --- /dev/null +++ b/challenge-206/luca-ferrari/blog-5.txt @@ -0,0 +1 @@ +https://fluca1978.github.io/2023/02/27/PerlWeeklyChallenge206.html#task1plpgsql diff --git a/challenge-206/luca-ferrari/blog-6.txt b/challenge-206/luca-ferrari/blog-6.txt new file mode 100644 index 0000000000..ffb4ce2f96 --- /dev/null +++ b/challenge-206/luca-ferrari/blog-6.txt @@ -0,0 +1 @@ +https://fluca1978.github.io/2023/02/27/PerlWeeklyChallenge206.html#task2plpgsql diff --git a/challenge-206/luca-ferrari/postgresql/ch-1.sql b/challenge-206/luca-ferrari/postgresql/ch-1.sql index 3165bc3a97..3f3e36f47b 100644 --- a/challenge-206/luca-ferrari/postgresql/ch-1.sql +++ b/challenge-206/luca-ferrari/postgresql/ch-1.sql @@ -33,5 +33,5 @@ BEGIN RETURN m; END -$CODE$ --foo +$CODE$ LANGUAGE plpgsql; diff --git a/challenge-206/luca-ferrari/postgresql/ch-2.sql b/challenge-206/luca-ferrari/postgresql/ch-2.sql index 3add7366d5..0c73ec4c72 100644 --- a/challenge-206/luca-ferrari/postgresql/ch-2.sql +++ b/challenge-206/luca-ferrari/postgresql/ch-2.sql @@ -15,8 +15,8 @@ DECLARE res int; BEGIN WITH data AS ( - SELECT v, row_number() OVER ( ORDER BY v ) r - FROM unnest( l ) v + SELECT v, row_number() OVER ( ORDER BY v ) r + FROM unnest( l ) v ) SELECT sum( v ) INTO res |