Wouldn't the semantics of IN seem to imply that the expression "foo IN <empty set>", should always evaluate to false? Clearly, "foo" is not in the empty set. I can't think of a use case where I'd use IN and want the expression "anything IN <empty set>" to evaluate to True. I'm another user who would use column.in_(<list>), where <list> is sometimes empty. Alternatively, is there a better way of expressing "true if an item is in a set, false otherwise"?
On Apr 12, 11:18 am, Michael Bayer <[EMAIL PROTECTED]> wrote: > On Apr 12, 2007, at 3:32 AM, svilen wrote: > > > it, but if it's once in a blue moon, u'll get one more disappointed > > SA user ;0(. > > right, and then i dont find out until i meet them at Pycon ;) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" 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/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---