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
|
