aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorLuca Ferrari <fluca1978@gmail.com>2023-01-23 12:14:44 +0100
committerLuca Ferrari <fluca1978@gmail.com>2023-01-23 12:14:44 +0100
commitd532740fe117f48b593a5abfc3761e9b45e73c26 (patch)
treeaca844bae181cf1fc7a6793c7d3461159bce3598
parentcee1163da54b67d4de0d0b99f983d8fd21f2bab1 (diff)
downloadperlweeklychallenge-club-d532740fe117f48b593a5abfc3761e9b45e73c26.tar.gz
perlweeklychallenge-club-d532740fe117f48b593a5abfc3761e9b45e73c26.tar.bz2
perlweeklychallenge-club-d532740fe117f48b593a5abfc3761e9b45e73c26.zip
Task 2 sql done
-rw-r--r--challenge-201/luca-ferrari/postgresql/ch-2.sql16
1 files changed, 16 insertions, 0 deletions
diff --git a/challenge-201/luca-ferrari/postgresql/ch-2.sql b/challenge-201/luca-ferrari/postgresql/ch-2.sql
new file mode 100644
index 0000000000..9e2afdb404
--- /dev/null
+++ b/challenge-201/luca-ferrari/postgresql/ch-2.sql
@@ -0,0 +1,16 @@
+--
+-- Perl Weekly Challenge 201
+-- Task 2
+--
+-- See <https://perlweeklychallenge.org/blog/perl-weekly-challenge-201/>
+--
+
+CREATE SCHEMA IF NOT EXISTS pwc201;
+
+CREATE OR REPLACE FUNCTION
+pwc201.task2_plpgsql( n int )
+RETURNS int
+AS $CODE$
+ SELECT pwc201.task2_plperl( n );
+$CODE$
+LANGUAGE sql;