| From: | jeff_patterson(at)agilent(dot)com |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | overlaps() bug? |
| Date: | 2002-02-12 18:54:17 |
| Message-ID: | 08E9E30FCA2CD5119BEA0090274066DF01D312FE@axcs16.cos.agilent.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Note the third row in the query result below is in error. The four hour
interval
(2300UTC - 0300UTC) does not overlap the interval 1530UTC-1627UTC). Is this
a bug? It would be cool if timetz (or time) datatypes were to wrap properly
across day boundaries (i.e. if start time < stop time then assume start time
is day before) but at the very least, the overlaps functions should not lie
to you!
Jeff Patterson
swl=# select freq,start,stop from sched where freq = '7200' and
swl-# overlaps(timetz '15:30UTC',timetz '16:27UTC',start,stop);
freq | start | stop
------+-------------+-------------
7200 | 15:30:00+00 | 16:27:00+00
7200 | 15:00:00+00 | 17:00:00+00
7200 | 23:00:00+00 | 03:00:00+00
7200 | 21:00:00+00 | 16:00:00+00
7200 | 16:00:00+00 | 19:00:00+00
7200 | 15:00:00+00 | 16:00:00+00
7200 | 20:00:00+00 | 16:00:00+00
7200 | 02:00:00+00 | 16:30:00+00
| Attachment | Content-Type | Size |
|---|---|---|
| Jeff Patterson (E-mail).vcf | application/octet-stream | 559 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Gamache | 2002-02-12 20:02:32 | Re: 7.1.3 : copy from stdin is very slow! |
| Previous Message | Bruce Momjian | 2002-02-12 18:27:03 | Re: [HACKERS] Feature enhancement request : use of libgda |