Repair swapped sign for time minus time routine (time_mi_time()).

Thomas G. Lockhart · Thomas G. Lockhart · commit 4bedbd061c97 · 2001-11-21T05:57:33.000Z
Problem reported by Manuel Sugawara (masm@fciencias.unam.mx).
diff --git 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.63 2001/10/25 05:49:43 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/utils/adt/date.c,v 1.64 2001/11/21 05:57:33 thomas Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -813,7 +813,7 @@ time_mi_time(PG_FUNCTION_ARGS)
 
 	result = (Interval *) palloc(sizeof(Interval));
 
-	result->time = time2 - time1;
+	result->time = time1 - time2;
 	result->month = 0;
 
 	PG_RETURN_INTERVAL_P(result);

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`*`
`9`	`9`	`*`
`10`	`10`	`* IDENTIFICATION`
`11`		`- * $Header: /cvsroot/pgsql/src/backend/utils/adt/date.c,v 1.63 2001/10/25 05:49:43 momjian Exp $`
	`11`	`+ * $Header: /cvsroot/pgsql/src/backend/utils/adt/date.c,v 1.64 2001/11/21 05:57:33 thomas Exp $`
`12`	`12`	`*`
`13`	`13`	`*-------------------------------------------------------------------------`
`14`	`14`	`*/`
`@@ -813,7 +813,7 @@ time_mi_time(PG_FUNCTION_ARGS)`
`813`	`813`
`814`	`814`	`result = (Interval *) palloc(sizeof(Interval));`
`815`	`815`
`816`		`- result->time = time2 - time1;`
	`816`	`+ result->time = time1 - time2;`
`817`	`817`	`result->month = 0;`
`818`	`818`
`819`	`819`	`PG_RETURN_INTERVAL_P(result);`