Sure, you probably know what you're doing. But anyone googling for MAX() + 1 should find this advice at the least :)
2016-09-14 13:57 GMT+02:00 BTJ <[email protected]>: > On Wednesday, September 14, 2016 at 1:50:07 PM UTC+2, Lukas Eder wrote: >> >> Hello, >> >> jOOQ supports all sorts of SQL expressions, including MAX() and +. Here's >> how: >> >> DSL.max(col).add(1) >> >> >> Do note, however, that this works only if you're the only process >> accessing the table concurrently. If you want to prevent race conditions on >> generated IDs, better use sequences, identity columns, auto_increment >> columns, or something similar. >> >> Hope this helps, >> Lukas >> >> > Yes, I know.. But this is an old table that we still use other places so > we don't want to change it at the moment.. > > Thx... :) > > > BTJ > > -- > 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.
