|
@RhodiumToad | |||||
|
A challenge: what SQL statement contains the longest possible sequence of consecutive keywords? (My best so far has 13 consecutive keywords)
|
||||||
|
||||||
|
RhodiumToad
@RhodiumToad
|
12. pro |
|
(Note, PostgreSQL accepts a number of cases of indefinite repetition, so I'm limiting this challenge to valid SQL 2016 foundation syntax)
|
||
|
|
||
|
RhodiumToad
@RhodiumToad
|
12. pro |
|
And now that Christoph has found a case where the spec allows a query of unbounded length using only keywords, let's limit it to cases with no loops
|
||
|
|
||
|
Torsten Grust
@Teggy
|
12. pro |
|
DML or DDL?
|
||
|
|
||
|
RhodiumToad
@RhodiumToad
|
12. pro |
|
Whichever you prefer...
|
||
|
|
||
|
Christoph Berg
@df7cb
|
12. pro |
|
select current_user union all select current_user union all select current_user union all select current_user;
|
||
|
|
||