Re: [sqlalchemy] How can I use the OVERLAPS operator?

2013-12-18 Thread Alex Grönholm
Ah, I was completely unaware of tuple_(). That's what I was looking for. Thanks! keskiviikko, 18. joulukuuta 2013 18.31.42 UTC+2 Michael Bayer kirjoitti: On Dec 17, 2013, at 8:39 PM, Alex Grönholm alex.g...@nextday.fijavascript: wrote: I would like to check if two date ranges overlap.

Re: [sqlalchemy] How can I use the OVERLAPS operator?

2013-12-18 Thread Michael Bayer
On Dec 17, 2013, at 8:39 PM, Alex Grönholm alex.gronh...@nextday.fi wrote: I would like to check if two date ranges overlap. This is done using the OVERLAPS operator. For example: SELECT (DATE '2001-02-16', DATE '2001-12-21') OVERLAPS (DATE '2001-10-30', DATE '2002-10-30'); How

[sqlalchemy] How can I use the OVERLAPS operator?

2013-12-17 Thread Alex Grönholm
I would like to check if two date ranges overlap. This is done using the OVERLAPS operator http://www.postgresql.org/docs/9.2/static/functions-datetime.html . For example: SELECT (DATE '2001-02-16', DATE '2001-12-21') OVERLAPS (DATE '2001-10-30', DATE '2002-10-30'); How do I do this in