diff options
| author | Luca Ferrari <fluca1978@gmail.com> | 2023-03-30 11:31:31 +0200 |
|---|---|---|
| committer | Luca Ferrari <fluca1978@gmail.com> | 2023-03-30 11:31:31 +0200 |
| commit | 7f46ff9b7117033f878f00ab876942132a0e9c3e (patch) | |
| tree | 4e14c0d901e644b4749511a1cb641d0440aaf65c | |
| parent | 218360eeabae3dfbc93a7617bcb7f2dc4f85054a (diff) | |
| download | perlweeklychallenge-club-7f46ff9b7117033f878f00ab876942132a0e9c3e.tar.gz perlweeklychallenge-club-7f46ff9b7117033f878f00ab876942132a0e9c3e.tar.bz2 perlweeklychallenge-club-7f46ff9b7117033f878f00ab876942132a0e9c3e.zip | |
Cheating on plpgsql tasks
| -rw-r--r-- | challenge-210/luca-ferrari/postgresql/ch-1.sql | 16 | ||||
| -rw-r--r-- | challenge-210/luca-ferrari/postgresql/ch-2.sql | 16 |
2 files changed, 32 insertions, 0 deletions
diff --git a/challenge-210/luca-ferrari/postgresql/ch-1.sql b/challenge-210/luca-ferrari/postgresql/ch-1.sql new file mode 100644 index 0000000000..2eae18f209 --- /dev/null +++ b/challenge-210/luca-ferrari/postgresql/ch-1.sql @@ -0,0 +1,16 @@ +-- +-- Perl Weekly Challenge 210 +-- Task 1 +-- +-- See <https://perlweeklychallenge.org/blog/perl-weekly-challenge-210/> +-- + +CREATE SCHEMA IF NOT EXISTS pwc210; + +CREATE OR REPLACE FUNCTION +pwc210.task1_plpgsql( l int[] ) +RETURNS int +AS $CODE$ + SELECT pwc210.task1_plperl( l ); +$CODE$ +LANGUAGE sql; diff --git a/challenge-210/luca-ferrari/postgresql/ch-2.sql b/challenge-210/luca-ferrari/postgresql/ch-2.sql new file mode 100644 index 0000000000..6d68d40fed --- /dev/null +++ b/challenge-210/luca-ferrari/postgresql/ch-2.sql @@ -0,0 +1,16 @@ +-- +-- Perl Weekly Challenge 210 +-- Task 2 +-- +-- See <https://perlweeklychallenge.org/blog/perl-weekly-challenge-210/> +-- + +CREATE SCHEMA IF NOT EXISTS pwc210; + +CREATE OR REPLACE FUNCTION +pwc210.task2_plpgsql( l int[] ) +RETURNS SETOF int +AS $CODE$ + SELECT pwc210.task2_plperl( l ); +$CODE$ +LANGUAGE sql; |