- changed status to resolved
Support for any() and all()
Issue #338
resolved
SQLAlchemy support the "in" operator in where clauses. Since Python 2.5 now has "any()" and "all()" functions for iterators, it would be nice if they existed in SQLAlchemy, too. They are used in PostgreSQL, for example: http://www.postgresql.org/docs/8.1/interactive/functions-comparisons.html
Also, I just noticed on http://www.sqlalchemy.org/docs/sqlconstruction.myt#sql_whereclause_operators, the sentence "Boolean operators include not_(), and() and or(), ...". Unfortunately, HTML generation has swallowed the underscores after and_ and or_, interpreting it as italics.
Comments (1)
-
repo owner - Log in to comment
id rather not add ANY/ALL to the core since these are not standard SQL operators. you can do (and ive seen people use):
etc.
fixed the doc formatting thing in the trunk and on the site.