On Jan 15, 2004, at 10:31 PM, Alvaro Herrera wrote:
Maybe it's tangential to this discussion, but there's a type to store that kind of intervals. It's called tinterval. ISTM it's not too much documented, and I haven't really used it.
alvherre=> select tinterval('2003-10-28', '2004-11-05'); tinterval ----------------------------------------------------- ["2003-10-28 00:00:00-03" "2004-11-05 00:00:00-03"] (1 fila)
alvherre=> select tinterval('2003-10-28', '2004-11-05') && tinterval('2003-10-05', '2003-10-15');
?column?
----------
f
(1 fila)
alvherre=> select tinterval('2003-10-28', '2004-11-05') && tinterval('2003-10-05', '2003-11-15');
?column?
----------
t
(1 fila)
(There are other operators, of course ...)
Well, lookee here! Thanks a lot, Alvaro!. Tangential or not, it's definitely something I'm interested in! More exploring to do!
Michael Glaesemann grzm myrealbox com
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
