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.
Well, there is a solution to this, which, I admit, I had to find on StackOverflow.
( https://stackoverflow.com/questions/47273373/postgres-crosstab-allocating-values-to-wrong-columns ) - I have implemented it in one of my solutions.
You can use VALUES command as second parameter of crosstab() function to specify an arbitrary column order, see section no. F.38.1.4 in the PostgreSQL 9.6 documentation.