try <somexpression>.op('OVERLAPS', <someotherexpression>)sagblmi wrote: > > Hi, > > How can I build an ORM query using the sql OVERLAPS operator? > > The overlaps operator can be expressed with the query: > > """ > SELECT * > FROM PERIOD > WHERE (P1_START > P2_START AND (P1_START < P2_FIN OR P1_FIN < > P2_FIN)) OR > (P2_START > P1_START AND (P2_START < P1_FIN OR P2_FIN < > P1_FIN)) OR > (P1_START = P2_START AND (P1_END IS NOT NULL AND P2_END IS NOT > NULL)) > > """ > > The following query has the same result but is optimilized by the db > engine: > > """ > SELECT * FROM PERIOD > WHERE (P1_START, P1_END) OVERLAPS (P2_START, P2_END); > """ > > Thank > > lmg > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
