diff options
| author | Mohammad S Anwar <Mohammad.Anwar@yahoo.com> | 2022-01-20 09:00:55 +0000 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-01-20 09:00:55 +0000 |
| commit | a09f0d53053cc4cf2ccd96a0a0fccf12fb1addea (patch) | |
| tree | bd01836ebe95148b48234ea47916cb198fe24406 /challenge-148/luca-ferrari/postgresql/ch-1.sql | |
| parent | 7cf8f31252ae9c14e175eed8c61dccabc132add9 (diff) | |
| parent | a38b1afc9d128849c177bdbfc6f32f0349e8d46b (diff) | |
| download | perlweeklychallenge-club-a09f0d53053cc4cf2ccd96a0a0fccf12fb1addea.tar.gz perlweeklychallenge-club-a09f0d53053cc4cf2ccd96a0a0fccf12fb1addea.tar.bz2 perlweeklychallenge-club-a09f0d53053cc4cf2ccd96a0a0fccf12fb1addea.zip | |
Merge pull request #5544 from fluca1978/PWC148
Pwc148
Diffstat (limited to 'challenge-148/luca-ferrari/postgresql/ch-1.sql')
| -rw-r--r-- | challenge-148/luca-ferrari/postgresql/ch-1.sql | 18 |
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 ); |