Re: [sqlalchemy] ORM query with overlaps operator

2013-05-13 Thread gio
This solution seems to work in my context Thanks Gio Am Mittwoch, 8. Mai 2013 16:18:31 UTC+2 schrieb Michael Bayer: from sqlalchemy.sql import column, tuple_ a, b = column('a'), column('b') print tuple_(a, b).op(OVERLAPS)(tuple_(1, 2)) (a, b) OVERLAPS (:param_1, :param_2) On May

Re: [sqlalchemy] ORM query with overlaps operator

2013-05-08 Thread Michael Bayer
from sqlalchemy.sql import column, tuple_ a, b = column('a'), column('b') print tuple_(a, b).op(OVERLAPS)(tuple_(1, 2)) (a, b) OVERLAPS (:param_1, :param_2) On May 8, 2013, at 6:39 AM, gio giovanni.lagr...@auditq.com wrote: Hi all Searching how to solve the

[sqlalchemy] ORM query with overlaps operator

2009-08-21 Thread David Bolen
Has anyone generated ORM queries using the OVERLAPS SQL operator that reference columns in the tables in the query? I've been experimenting with various approaches and can't seem to cleanly get the column names (with their appropriate alias based on the rest of the query) into the overlaps