[SQLObject] How to use OVERLAPS keyword with SQLObject?
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
|
From: Matthew W. <ma...@tp...> - 2008-07-24 18:25:32
|
I just learned about the OVERLAPS keyword, used like this: matt=# select (TIMESTAMP '2008-07-24 03:00:00', TIMESTAMP '2008-07-24 09:00:00') overlaps (TIMESTAMP '2008-07-24 5:0:0', TIMESTAMP '2008-07-24 11:0:0') ; overlaps ---------- t (1 row) I'm testing if the time interval from 3 AM today through 9 AM today overlaps the time interval from 5 AM through 11 AM. How can I use this with SQLObject? I poked around a little with SQLOp. Before I write an ugly patch, is there already a way to do it? It is important to use the TIMESTAMP label to disambiguate types. Matt |