postgres.git / summary / log / commit / refs

commit    9524c6b8aedecfcea77287b4f6452288dcf8dc7a
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Sat Apr 23 22:54:23 2005 +0000
First released in: 8.1.0, 7.2.8, 7.3.10, 7.4.8, 8.0.3

    Repair two TIME WITH TIME ZONE bugs found by Dennis Vshivkov.  Comparison
    of timetz values misbehaved in --enable-integer-datetime cases, and
    EXTRACT(EPOCH) subtracted the zone instead of adding it in all cases.
    Backpatch to all supported releases (except --enable-integer-datetime code
    does not exist in 7.2).


 src/backend/utils/adt/date.c | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/src/backend/utils/adt/date.c b/src/backend/utils/adt/date.c
index 03051dd4b19..f14d2f7a7b2 100644
--- a/src/backend/utils/adt/date.c
+++ b/src/backend/utils/adt/date.c
@@ -8,7 +8,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/utils/adt/date.c,v 1.64.2.3 2002/09/30 20:57:10 tgl Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/utils/adt/date.c,v 1.64.2.4 2005/04/23 22:54:23 tgl Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -1553,7 +1553,7 @@ timetz_part(PG_FUNCTION_ARGS)
 		}
 	}
 	else if ((type == RESERV) && (val == DTK_EPOCH))
-		result = time->time - time->zone;
+		result = time->time + time->zone;
 	else
 	{
 		elog(ERROR, "TIMETZ units '%s' not recognized",


[parent: 6fbda165183f]