aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorLuca Ferrari <fluca1978@gmail.com>2022-10-17 12:30:10 +0200
committerLuca Ferrari <fluca1978@gmail.com>2022-10-17 12:30:10 +0200
commita0f25c254c35d5a27690703cccd9d6acd0131ce8 (patch)
tree6a67a5c0906faaafa6ab2c69e62fafcf4f1fd211
parent1ec78ddc196cd94ca8f197351bd0ad15bb18a0d0 (diff)
downloadperlweeklychallenge-club-a0f25c254c35d5a27690703cccd9d6acd0131ce8.tar.gz
perlweeklychallenge-club-a0f25c254c35d5a27690703cccd9d6acd0131ce8.tar.bz2
perlweeklychallenge-club-a0f25c254c35d5a27690703cccd9d6acd0131ce8.zip
Task 2 plpgsql
-rw-r--r--challenge-187/luca-ferrari/postgresql/ch-2.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/challenge-187/luca-ferrari/postgresql/ch-2.sql b/challenge-187/luca-ferrari/postgresql/ch-2.sql
new file mode 100644
index 0000000000..f9659e9ac2
--- /dev/null
+++ b/challenge-187/luca-ferrari/postgresql/ch-2.sql
@@ -0,0 +1,15 @@
+-- Perl Weekly Challenge 187
+-- Task 2
+
+
+CREATE SCHEMA IF NOT EXISTS pwc187;
+
+CREATE OR REPLACE FUNCTION
+pwc187.task2_plpgsql( a int[] )
+RETURNS int[]
+AS $CODE$
+BEGIN
+ RETURN pwc187.task2_plperl( a );
+END
+$CODE$
+LANGUAGE plpgsql;