Manlio Perillo wrote: > > Hi. > > Is it possible, in SQLAlchemy, to express this query? > > CREATE TEMP TABLE foo ( > x INTEGER, > y INTEGER > ); > > INSERT INTO foo VALUES (10, 11); > INSERT INTO foo VALUES (1, 2); > > manlio=> SELECT * FROM foo WHERE (x, y) in (VALUES (1, 2), (3, 4)); > x | y > - ---+--- > 1 | 2 > (1 riga) > > > This should be standard SQL. > It is supported by PostgreSQL [1], but SQLite fails with a > syntax error. > > > [1] http://www.postgresql.org/docs/8.4/static/sql-values.html > > > Thanks Manlio
Does the following thread help at all? http://groups.google.com/group/sqlalchemy/browse_thread/thread/7f950b628 d7ebee5/4421b272d4c7f91f Hope that helps, Simon -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.