Fix lookup tables used for rounding interval data values when not using

Thomas G. Lockhart · Thomas G. Lockhart · commit cc2ce8363350 · 2002-05-14T13:37:27.000Z
integer datetimes. Thanks to Tom Lane for spotting the problem.
diff --git a/src/backend/utils/adt/timestamp.c b/src/backend/utils/adt/timestamp.c
@@ -8,7 +8,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/utils/adt/timestamp.c,v 1.66 2002/04/21 19:48:13 thomas Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/utils/adt/timestamp.c,v 1.67 2002/05/14 13:37:27 thomas Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -463,23 +463,23 @@ AdjustIntervalForTypmod(Interval *interval, int32 typmod)
 	};
 #else
 	static const double IntervalScales[MAX_INTERVAL_PRECISION+1] = {
-		1000000,
-		100000,
-		10000,
-		1000,
-		100,
+		1,
 		10,
-		1
+		100,
+		1000,
+		10000,
+		100000,
+		1000000
 	};
 
 	static const double IntervalOffsets[MAX_INTERVAL_PRECISION+1] = {
-		-500000,
-		-50000,
-		-5000,
-		-500,
-		-50,
-		-5,
-		0
+		0.5,
+		0.05,
+		0.005,
+		0.0005,
+		0.00005,
+		0.000005,
+		0.0000005
 	};
 #endif
 
