Re: Bug and/or feature? Complex data types in tables...

Hi Alvaro,

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