diff options
| author | Luca Ferrari <fluca1978@gmail.com> | 2023-05-29 14:34:26 +0200 |
|---|---|---|
| committer | Luca Ferrari <fluca1978@gmail.com> | 2023-05-29 14:34:26 +0200 |
| commit | 4328a8a9463494359f936811cc2568237292ced1 (patch) | |
| tree | 2bf59f2167485560aa102fb300d5c5974357d359 | |
| parent | 786c47542b92b279edcd6a80e7eae5f48702736b (diff) | |
| download | perlweeklychallenge-club-4328a8a9463494359f936811cc2568237292ced1.tar.gz perlweeklychallenge-club-4328a8a9463494359f936811cc2568237292ced1.tar.bz2 perlweeklychallenge-club-4328a8a9463494359f936811cc2568237292ced1.zip | |
Task 1 sql done
| -rw-r--r-- | challenge-219/luca-ferrari/postgresql/ch-1.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/challenge-219/luca-ferrari/postgresql/ch-1.sql b/challenge-219/luca-ferrari/postgresql/ch-1.sql new file mode 100644 index 0000000000..b77d9878ae --- /dev/null +++ b/challenge-219/luca-ferrari/postgresql/ch-1.sql @@ -0,0 +1,18 @@ +-- +-- Perl Weekly Challenge 219 +-- Task 1 +-- +-- See <https://perlweeklychallenge.org/blog/perl-weekly-challenge-219/> +-- + +CREATE SCHEMA IF NOT EXISTS pwc219; + +CREATE OR REPLACE FUNCTION +pwc219.task1_plpgsql( n int[] ) +RETURNS SETOF int +AS $CODE$ + SELECT v * v + FROM unnest( n ) v + ORDER BY 1 +$CODE$ +LANGUAGE sql; |