I have seen following regression failure with current(I cvs up'ed 10
minutes ago). Any thought? This is Linux kernel 2.4.22 with glibc
2.2.4.
--
Tatsuo Ishii

*** ./expected/horology.out     Mon Sep 29 17:53:48 2003
--- ./results/horology.out      Sun Oct 26 20:21:59 2003
***************
*** 583,595 ****
  SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - 
interval '1 day')) as "True";
   True 
  ------
!  t
  (1 row)
  
  SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' 
+ interval '2 days')) as "True";
   True 
  ------
!  t
  (1 row)
  
  SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
--- 583,595 ----
  SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - 
interval '1 day')) as "True";
   True 
  ------
!  f
  (1 row)
  
  SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' 
+ interval '2 days')) as "True";
   True 
  ------
!  f
  (1 row)
  
  SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
***************
*** 836,842 ****
              + interval '02:01' AS time with time zone) AS time) AS "03:31:00";
   03:31:00 
  ----------
!  03:31:00
  (1 row)
  
  SELECT CAST(cast(date 'today' + time with time zone '03:30'
--- 836,842 ----
              + interval '02:01' AS time with time zone) AS time) AS "03:31:00";
   03:31:00 
  ----------
!  02:31:00
  (1 row)
  
  SELECT CAST(cast(date 'today' + time with time zone '03:30'

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



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to