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