I am seeing the attached regression diffs on timetz, which passed
last week.  It looks like all of these are related to the fact that
unmarked timetz values are now presumed to be PST (-8) not PST (-7).

			regards, tom lane

*** ./expected/timetz.out	Wed Oct  3 01:29:26 2001
--- ./results/timetz.out	Tue Oct 30 12:51:38 2001
***************
*** 33,62 ****
   00:01:00-07
   01:00:00-07
   02:03:00-07
! (3 rows)
  
  SELECT f1 AS "Seven" FROM TIMETZ_TBL WHERE f1 > '05:06:07';
       Seven      
  ----------------
   07:07:00-08
-  08:08:00-04
   11:59:00-07
   12:00:00-07
   12:01:00-07
   23:59:00-07
   23:59:59.99-07
! (7 rows)
  
  SELECT f1 AS "None" FROM TIMETZ_TBL WHERE f1 < '00:00';
   None 
! ------
! (0 rows)
  
  SELECT f1 AS "Ten" FROM TIMETZ_TBL WHERE f1 >= '00:00';
        Ten       
  ----------------
-  00:01:00-07
-  01:00:00-07
   02:03:00-07
   07:07:00-08
   08:08:00-04
--- 33,62 ----
   00:01:00-07
   01:00:00-07
   02:03:00-07
!  08:08:00-04
! (4 rows)
  
  SELECT f1 AS "Seven" FROM TIMETZ_TBL WHERE f1 > '05:06:07';
       Seven      
  ----------------
   07:07:00-08
   11:59:00-07
   12:00:00-07
   12:01:00-07
   23:59:00-07
   23:59:59.99-07
! (6 rows)
  
  SELECT f1 AS "None" FROM TIMETZ_TBL WHERE f1 < '00:00';
      None     
! -------------
!  00:01:00-07
!  01:00:00-07
! (2 rows)
  
  SELECT f1 AS "Ten" FROM TIMETZ_TBL WHERE f1 >= '00:00';
        Ten       
  ----------------
   02:03:00-07
   07:07:00-08
   08:08:00-04
***************
*** 65,71 ****
   12:01:00-07
   23:59:00-07
   23:59:59.99-07
! (10 rows)
  
  --
  -- TIME simple math
--- 65,71 ----
   12:01:00-07
   23:59:00-07
   23:59:59.99-07
! (8 rows)
  
  --
  -- TIME simple math

======================================================================


Tue, 30 Oct 2001 13:00:18 -0500
Tom Lane <tgl@sss.pgh.pa.us>
timetz regression test is showing several DST-related failures
I said:
> I am seeing the attached regression diffs on timetz, which passed
> last week.  It looks like all of these are related to the fact that
> unmarked timetz values are now presumed to be PST (-8) not PST (-7).

Sigh, make that "PST (-8) not PDT (-7)"

			regards, tom lane

Tue, 30 Oct 2001 15:16:14 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: timetz regression test is showing several DST-related failures 
> > I am seeing the attached regression diffs on timetz, which passed
> > last week.  It looks like all of these are related to the fact that
> > unmarked timetz values are now presumed to be PST (-8) not PST (-7).
> Sigh, make that "PST (-8) not PDT (-7)"

Whatever. I'll look at them to see if I can formulate a test which fills
in the blanks correctly.

Nothing like a useless data type which is *also* a pita :/

                   - Thomas

Wed, 31 Oct 2001 05:58:46 +0000
Thomas Lockhart <lockhart@fourpalms.org>
Re: timetz regression test is showing several DST-related 
> I am seeing the attached regression diffs on timetz, which passed
> last week.  It looks like all of these are related to the fact that
> unmarked timetz values are now presumed to be PST (-8) not PST (-7).

OK, I've updated the regression test by including an explicit time zone
in the query constants. All tests pass on my Linux box.

                    - Thomas

Wed, 31 Oct 2001 14:47:51 +0000
Thomas Lockhart <lockhart@fourpalms.org>
Re: timetz regression test is showing several DST-related failures