aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--challenge-148/luca-ferrari/postgresql/ch-1.sql18
1 files changed, 18 insertions, 0 deletions
diff --git a/challenge-148/luca-ferrari/postgresql/ch-1.sql b/challenge-148/luca-ferrari/postgresql/ch-1.sql
new file mode 100644
index 0000000000..a1782662de
--- /dev/null
+++ b/challenge-148/luca-ferrari/postgresql/ch-1.sql
@@ -0,0 +1,18 @@
+ SELECT v
+ FROM generate_series( 1, 10 ) v
+ WHERE
+ v IN ( 2, 4, 6 )
+
+ UNION
+
+ SELECT v
+ FROM generate_series( 11, 19 ) v
+ WHERE v IN ( 12 )
+
+ UNION
+
+ SELECT v
+ FROM generate_series( 20, 100 ) v
+ WHERE
+ v % 10 IN ( 2, 4, 6 )
+ AND ( v / 10 )::int IN ( 3, 4, 5, 6 );