| From: | Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | strange overlaps? |
| Date: | 2005-03-23 15:12:54 |
| Message-ID: | Pine.LNX.4.44.0503231606370.26873-100000@kix.fsv.cvut.cz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tony | 2005-03-23 15:22:14 | Re: OSX, ODBC and Office 2004 |
| Previous Message | Scott Marlowe | 2005-03-23 15:08:20 | Re: PostgreSQL support |