Hi Mark, >From the official side, we haven't investigated much into this topic. There's still this open feature request (which was triggered by this discussion): https://github.com/jOOQ/jOOQ/issues/3190
But given the fact that a plain SQL workaround is perfectly possible, we haven't implemented it yet. Let me know if you need any help with that workaround. Cheers, Lukas 2016-12-22 4:20 GMT+01:00 Mark Derricutt <[email protected]>: > 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. > -- 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.
