Christoph Zwerschke wrote: > Janzert schrieb: >> My understanding and testing seem to show that an inner join doesn't >> return duplicates. Wrapping the result in a set doesn't seem necessary. > > The query creates duplicates, and they are pulled from the database, but > they are removed by SQLAlchemy because you are querying object instances > and it makes no sense for SQLAlchemy to deliver duplicates in this case.
Ah yes, by running the generated sql directly I see that now. I'll try and see if there is a way to generate the exists clause that is compatible with 0.3 on up. Janzert --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---

