postgres
diff --git a/‎src/backend/access/gist/gistscan.c
Copy file name to clipboardExpand all lines: src/backend/access/gist/gistscan.c
+5-2Lines changed: 5 additions & 2 deletions b/‎src/backend/access/gist/gistscan.c
Copy file name to clipboardExpand all lines: src/backend/access/gist/gistscan.c
+5-2Lines changed: 5 additions & 2 deletions
diff --git a/‎src/test/regress/expected/create_index.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/create_index.out
+5-5Lines changed: 5 additions & 5 deletions b/‎src/test/regress/expected/create_index.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/create_index.out
+5-5Lines changed: 5 additions & 5 deletions
@@ -17,6 +17,7 @@
 #include "access/gist_private.h"
 #include "access/gistscan.h"
 #include "access/relscan.h"
+#include "utils/float.h"
 #include "utils/lsyscache.h"
 #include "utils/memutils.h"
 #include "utils/rel.h"
@@ -36,8 +37,10 @@ pairingheap_GISTSearchItem_cmp(const pairingheap_node *a, const pairingheap_node
 	/* Order according to distance comparison */
 	for (i = 0; i < scan->numberOfOrderBys; i++)
 	{
-		if (sa->distances[i] != sb->distances[i])
-			return (sa->distances[i] < sb->distances[i]) ? 1 : -1;
+		int			cmp = -float8_cmp_internal(sa->distances[i], sb->distances[i]);
+
+		if (cmp != 0)
+			return cmp;
 	}
 
 	/* Heap items go before inner pages, to ensure a depth-first search */
 
@@ -523,16 +523,16 @@ SELECT * FROM point_tbl ORDER BY f1 <-> '0,1';
 SELECT * FROM point_tbl ORDER BY f1 <-> '0,1';
         f1         
 -------------------
- (10,10)
- (NaN,NaN)
  (0,0)
  (1e-300,-1e-300)
  (-3,4)
  (-10,0)
+ (10,10)
  (-5,-12)
  (5.1,34.5)
- 
  (1e+300,Infinity)
+ 
+ (NaN,NaN)
 (10 rows)
 
 EXPLAIN (COSTS OFF)
@@ -561,15 +561,15 @@ SELECT * FROM point_tbl WHERE f1 IS NOT NULL ORDER BY f1 <-> '0,1';
 SELECT * FROM point_tbl WHERE f1 IS NOT NULL ORDER BY f1 <-> '0,1';
         f1         
 -------------------
- (10,10)
- (NaN,NaN)
  (0,0)
  (1e-300,-1e-300)
  (-3,4)
  (-10,0)
+ (10,10)
  (-5,-12)
  (5.1,34.5)
  (1e+300,Infinity)
+ (NaN,NaN)
 (9 rows)
 
 EXPLAIN (COSTS OFF)