Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme  | Privacy 

Postgres CrossTab for query with variable number of columns

Language: Layout:
absolute service time: 0,81 sec 
edit mode |  history  | discussion
   stop_id shift_items
1 220 {"shift1": [14, 16], "shift2": [12], "shift3": [14]}
2 221 {"shift1": [15, 17], "shift2": [null], "shift3": [15, 16]}
3 222 {"shift1": [16], "shift2": [1, 9], "shift3": [null]}

    
                

Want a library, package, new language or a feature?

Or perhaps a link to your site?

Become a patron and get the things you want.

Rextester's Patreon