Did anything come of including PostgreSQL crosstab() support officially inside JOOQ at all? I've just been working on some code and need just that functionality ( well, it works running 4-5 separate queries, but this is much more performant ) and was wondering if there was a JOOQy way of doing it yet...
On Tuesday, September 15, 2015 at 2:11:02 PM UTC+12, [email protected] wrote: > > On Friday, September 11, 2015 at 7:12:00 PM UTC+10, Lukas Eder wrote: >> >> >> >> 2015-09-11 6:14 GMT+02:00 <[email protected]>: >> >>> I'll try to come up with a small example of what I'm trying to achieve >>> in (2) above, and perhaps that will be a good way to discuss it further. I >>> had a quick go, but I made the example too simple, and so it didn't make >>> much sense. I'll see if I can get to it over the weekend. (We're releasing >>> at the moment, so time's at a bit of a premium). >>> >> >> No worries. With these edge-cases, a "whatever works" situation can be >> good enough some times :) >> > > > I've made a gist which I think can be accessed here > > https://gist.github.com/joe-thurbon/f6bff4732afb8aed609c > > It contains a really simple example of sql, and some java that can be > compiled against appropriately generated jooq classes. > > Can you let me know if I've given enough info and the gist is visible > (I've not done it before). > > There's a method called demonstrate(DSLContext) which I think shows what > I'm trying to do. > > Cheers. > Joe > -- 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.
