From: Matthew Wilson <matt@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
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.
On Thu, Jul 24, 2008 at 06:25:20PM +0000, Matthew Wilson wrote:
> I poked around a little with SQLOp. Before I write an ugly patch, is
> there already a way to do it?
There is no.
Oleg Broytmann http://phd.pp.ru/ phd@...
Programmers don't die, they just GOSUB without RETURN.