No worries ;-) Anyway, this is now in the works for jOOQ 3.11. PostgreSQL will see quite a few implementations being delegated to native support. In other databases, some of the DateParts can be emulated (e.g. millennium, century, decade, quarter, etc.)
Thanks, Lukas Am Donnerstag, 8. Februar 2018 15:25:37 UTC+1 schrieb Malte Schirmacher: > > Hey Lukas, > > of course you are right - in fact that's the reason. > Didn't meant to offend you in any way :-) > > Am Mittwoch, 7. Februar 2018 14:24:41 UTC+1 schrieb Lukas Eder: >> >> Hi Malte, >> >> The reason you perceive this rather remote missing feature for a >> vendor-specific set of functionality as "ridiculous" is quite likely >> because up until now, you've found jOOQ to be otherwise so extremely >> powerful that you're completely surprised there's a thing that doesn't work >> (yet). >> >> Rest assured. It's on the roadmap, and will be implemented eventually. >> >> Thanks, >> Lukas >> >> 2018-02-07 12:44 GMT+01:00 'Malte Schirmacher' via jOOQ User Group < >> jooq...@googlegroups.com>: >> >>> Hi Lukas, >>>> >>>> >>> thank you very much for your answer. >>> The first suggested solution, despite being somewhat cumbersome, will do >>> for my use case. Thanks for pointing this out :-) >>> >>> Yes i understand that adding WEEK isn't that easy. OTOH it's ridiculous, >>> that one missing Enum field is causing so much trouble (generate_series is >>> not the only thing. I also make use of DSL.trunc() and had to implement it >>> again to make use of week-based truncation). >>> >>> I subscribed to the issue you kindly opened and am looking forward to >>> refactor to a more convenient solution as soon as the issue is closed :-) >>> >>> -- >>> 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 jooq-user+...@googlegroups.com. >>> 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 jooq-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.