Thread: strange overlaps?

strange overlaps?

From
Pavel Stehule
Date:
Hello,

it's true?

tarif=# select ('10:10:10'::time,'10min'::interval) overlaps
('18:00:00'::time, '6hours'::interval);
 overlaps
----------
 t
(1 row)

I think not. There is problem in overflow one parametr.

tarif=# select ('06:10:10'::time,'1min'::interval) overlaps
('18:00:00'::time, '5hours 59min'::interval);
 overlaps
----------
 f
(1 row)

tarif=# select version();
                                                 version
---------------------------------------------------------------------------------------------------------
 PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2
20031022 (Red Hat Linux 3.3.2-1)
(1 row)

Regards
Pavel Stehule