2013/8/15 Ryan How <[email protected]> > Thanks Lukas! > > I didn't realise you can do multiple .selects. >
Yeah, that was one of the rather weird ideas I had in the early days of jOOQ. I'm not sure if I really like it... > I tried .select().select(OtherStuff), but it only returned OtherStuff, > Hmm, yes that seems to be an API design flaw of the current solution. While .select() generates an empty projection, which is interpreted by jOOQ as a SELECT * projection, adding OtherStuff will render the projection non-empty. I guess that's correct but a little weird. > it isn't too bad to specify table.fields() for each of the tables though :) > Well, you do have table.fields(): http://www.jooq.org/javadoc/latest/org/jooq/TableLike.html#fields() But that returns a concrete, materialised Field<?>[]. That's not exactly the same as using an actual asterisk, whose product can be transformed through SQL (e.g. through JOIN .. USING, or NATURAL JOIN) Cheers Lukas -- 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/groups/opt_out.
