postgres
diff --git a/‎contrib/btree_gin/btree_gin.c
Copy file name to clipboardExpand all lines: contrib/btree_gin/btree_gin.c
+3-3Lines changed: 3 additions & 3 deletions b/‎contrib/btree_gin/btree_gin.c
Copy file name to clipboardExpand all lines: contrib/btree_gin/btree_gin.c
+3-3Lines changed: 3 additions & 3 deletions
diff --git a/‎contrib/btree_gin/expected/interval.out
Copy file name to clipboardExpand all lines: contrib/btree_gin/expected/interval.out
+11-5Lines changed: 11 additions & 5 deletions b/‎contrib/btree_gin/expected/interval.out
Copy file name to clipboardExpand all lines: contrib/btree_gin/expected/interval.out
+11-5Lines changed: 11 additions & 5 deletions
diff --git a/‎contrib/btree_gin/sql/interval.sql
Copy file name to clipboardExpand all lines: contrib/btree_gin/sql/interval.sql
+3-1Lines changed: 3 additions & 1 deletion b/‎contrib/btree_gin/sql/interval.sql
Copy file name to clipboardExpand all lines: contrib/btree_gin/sql/interval.sql
+3-1Lines changed: 3 additions & 1 deletion
@@ -306,9 +306,9 @@ leftmostvalue_interval(void)
 {
 	Interval   *v = palloc(sizeof(Interval));
 
-	v->time = DT_NOBEGIN;
-	v->day = 0;
-	v->month = 0;
+	v->time = PG_INT64_MIN;
+	v->day = PG_INT32_MIN;
+	v->month = PG_INT32_MIN;
 	return IntervalPGetDatum(v);
 }
 
 
@@ -3,30 +3,34 @@ CREATE TABLE test_interval (
 	i interval
 );
 INSERT INTO test_interval VALUES
+	( '-178000000 years' ),
 	( '03:55:08' ),
 	( '04:55:08' ),
 	( '05:55:08' ),
 	( '08:55:08' ),
 	( '09:55:08' ),
-	( '10:55:08' )
+	( '10:55:08' ),
+	( '178000000 years' )
 ;
 CREATE INDEX idx_interval ON test_interval USING gin (i);
 SELECT * FROM test_interval WHERE i<'08:55:08'::interval ORDER BY i;
             i             
 --------------------------
+ @ 178000000 years ago
  @ 3 hours 55 mins 8 secs
  @ 4 hours 55 mins 8 secs
  @ 5 hours 55 mins 8 secs
-(3 rows)
+(4 rows)
 
 SELECT * FROM test_interval WHERE i<='08:55:08'::interval ORDER BY i;
             i             
 --------------------------
+ @ 178000000 years ago
  @ 3 hours 55 mins 8 secs
  @ 4 hours 55 mins 8 secs
  @ 5 hours 55 mins 8 secs
  @ 8 hours 55 mins 8 secs
-(4 rows)
+(5 rows)
 
 SELECT * FROM test_interval WHERE i='08:55:08'::interval ORDER BY i;
             i             
@@ -40,12 +44,14 @@ SELECT * FROM test_interval WHERE i>='08:55:08'::interval ORDER BY i;
  @ 8 hours 55 mins 8 secs
  @ 9 hours 55 mins 8 secs
  @ 10 hours 55 mins 8 secs
-(3 rows)
+ @ 178000000 years
+(4 rows)
 
 SELECT * FROM test_interval WHERE i>'08:55:08'::interval ORDER BY i;
              i             
 ---------------------------
  @ 9 hours 55 mins 8 secs
  @ 10 hours 55 mins 8 secs
-(2 rows)
+ @ 178000000 years
+(3 rows)
 
@@ -5,12 +5,14 @@ CREATE TABLE test_interval (
 );
 
 INSERT INTO test_interval VALUES
+	( '-178000000 years' ),
 	( '03:55:08' ),
 	( '04:55:08' ),
 	( '05:55:08' ),
 	( '08:55:08' ),
 	( '09:55:08' ),
-	( '10:55:08' )
+	( '10:55:08' ),
+	( '178000000 years' )
 ;
 
 CREATE INDEX idx_interval ON test_interval USING gin (i);
Original file line number	Diff line number	Diff line change
`@@ -306,9 +306,9 @@ leftmostvalue_interval(void)`
`306`	`306`	`{`
`307`	`307`	`Interval *v = palloc(sizeof(Interval));`
`308`	`308`
`309`		`- v->time = DT_NOBEGIN;`
`310`		`- v->day = 0;`
`311`		`- v->month = 0;`
	`309`	`+ v->time = PG_INT64_MIN;`
	`310`	`+ v->day = PG_INT32_MIN;`
	`311`	`+ v->month = PG_INT32_MIN;`
`312`	`312`	`return IntervalPGetDatum(v);`
`313`	`313`	`}`
`314`	`314`