Sorry I forgot to mention the motivation for this - in certain more complicated queries it is easier to figure out the intention of DISTINCT ON as opposed to FIND FIRST/PARTITION OVER, even though they are functionally equivalent. This helps when you go back to revisit a largish query and were wondering why a window function was used.
On Tue, Jun 9, 2015 at 1:43 PM, Ben Hood <[email protected]> wrote: > Hi Lukas, > > Can I vote for https://github.com/jOOQ/jOOQ/issues/3564 please? Right > now we have to work around DISTINCT ON with a row num clause, so this > would be a welcomed addition. > > Cheers, > > Ben -- 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.
