| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | lockhart(at)fourpalms(dot)org |
| Cc: | Robert Hentosh <hentosh(at)io(dot)com>, JayGuerette(at)pobox(dot)com, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Re: PostgreSQL 7.0.2 Date Miscalculation |
| Date: | 2001-04-03 16:08:06 |
| Message-ID: | 3446.986314086@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> writes:
>> --- ./results/horology.out Mon Apr 2 17:06:59 2001
>> SELECT time with time zone '01:30' + interval '02:01' AS "03:31:00-08";
>> 03:31:00-08
>> -------------
>> ! 03:31:00-07
> Hmm. This is just a badly designed regression test (I can say that,
> since it is probably mine ;)
> I was trying to exercise TIME WITH TIME ZONE with the *implicit* time
> zone for today. That really won't work in a testable way, since the
> result varies during the year :(
What I'm curious about is why I'm not seeing a failure on HPUX. If your
explanation is right then this test should fail everywhere during
daylight savings season.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 2001-04-03 16:48:52 | Re: Re: PostgreSQL 7.0.2 Date Miscalculation |
| Previous Message | Thomas Lockhart | 2001-04-03 15:52:45 | Re: PostgreSQL 7.0.2 Date Miscalculation |