That makes sense - thanks again.
Martin On May 27, 9:09 pm, Michael Bayer <[EMAIL PROTECTED]> wrote: > On May 27, 2008, at 3:11 PM, Martin Pengelly-Phillips wrote: > > > > > Hi Michael, > > > Thank you for the quick response. I had thought about using a > > straightforward OR statement - are you suggesting that this would form > > the body of the in_() method on the Comparator or were you referring > > more to just compiling the OR statements in the base query? > > i was saying the result of in_() would be a construct like: > > or_(*[col1.in_([x,y,z]), col2.in_([d, e, f]), ...]) > > > Also, what is the correct expression for defining a subquery with the > > ORM interface (I gather my embedded session.query statement currently > > evaluates as a separate statement to return the list of candidates). > > any select() constituites a subquery when placed wihtin an enclosing > select(). Often its a good idea to further enclose it in an Alias > construct by saying select().alias(). Read through the SQL expression > tutorial for examples. > > the subquery() method on Query wouldn't be used inside of a Comparator > since theres no Query object available in those methods and its an > overly heavy-handed approach at that level. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---