Loading collection data...
Collections are a way for you to organize kata so that you can create your own training routines. Every collection you create is public and automatically sharable with other warriors. After you have added a few kata to a collection you and others can train on the kata contained within the collection.
Get started now by creating a new collection.
A table has no order, so
SELECT * FROM T
is by definition in a random orderDoes not appear to be working for SQL (postgres 9.6). It says expected 17 results, 0 found (or something similar). I validated my function against a real psql 9.6 and it works.
I asked what a set of elves should be called (a table is a set of tuples and a header). What would you call a collection of elves in an application?
Nice kata, the DFA (FSM): http://aswitalski.github.io/img/FSM-binary-divisible-by-five.png accepts the empty string, but that is not correct according to the sample test.
No matter what I do, I get one error stating:
Test Failed
! , , , ,--- , ,...
@@,employee_id,first_name,last_name,department_id,department_name,...
and nothing more. If I deliberate replace for example department_name with 'a' I get an indication for each row that the name is wrong, but everything else is ok.
I even dumped the content of the function for all departments and hard coded them in the query, but to no avail
I had the same consideration, perhaps it should be in the instructions that there can be more than 2 prime "factors"?
what do you call a set of elves?