On Wed, Apr 16, 2014 at 11:43 AM, Lukas Eder <[email protected]> wrote: >> I guess the other option would be be to define views for each column >> in the pivot and and then left outer join on each view. But that's no >> JOOQ :-( > > > I'm not sure if I understand this correctly? Do you think that such views > would be reusable?
What I meant was that if there are n attributes to pivot on, then you define a separate view per attribute using the attribute name in the where clause for the view definition. Then you could define a query that does a left outer join over the n views, grouping by the attribute you want to group on. This would create all of the "pivot" columns in the result set. But that's a lot of maintenance. -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
