aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/expected/create_index.out26
-rw-r--r--src/test/regress/sql/create_index.sql2
2 files changed, 14 insertions, 14 deletions
diff --git a/src/test/regress/expected/create_index.out b/src/test/regress/expected/create_index.out
index 71aee762256..59016d5ed74 100644
--- a/src/test/regress/expected/create_index.out
+++ b/src/test/regress/expected/create_index.out
@@ -387,19 +387,19 @@ SELECT * FROM gpolygon_tbl ORDER BY f1 <-> '(0,0)'::point LIMIT 10;
((2424,81),(2424,160),(2424,160),(2424,81))
(10 rows)
-SELECT * FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10;
- f1
------------------------------------
- <(288.5,407),68.2367203197809>
- <(710.5,175),49.9624859269432>
- <(323.5,1433),51.4417145903983>
- <(927.5,1178.5),30.4384625104489>
- <(1395,373.5),57.1948424248201>
- <(1555.5,1007),52.7091073724456>
- <(217,1835),44.5982062419555>
- <(489,2421.5),22.3886131772381>
- <(2424,120.5),39.5>
- <(751.5,2655),20.4022057631032>
+SELECT circle_center(f1), round(radius(f1)) as radius FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10;
+ circle_center | radius
+----------------+--------
+ (288.5,407) | 68
+ (710.5,175) | 50
+ (323.5,1433) | 51
+ (927.5,1178.5) | 30
+ (1395,373.5) | 57
+ (1555.5,1007) | 53
+ (217,1835) | 45
+ (489,2421.5) | 22
+ (2424,120.5) | 40
+ (751.5,2655) | 20
(10 rows)
-- Now check the results from plain indexscan
diff --git a/src/test/regress/sql/create_index.sql b/src/test/regress/sql/create_index.sql
index acbfbd51332..39a94998a08 100644
--- a/src/test/regress/sql/create_index.sql
+++ b/src/test/regress/sql/create_index.sql
@@ -226,7 +226,7 @@ SELECT count(*) FROM radix_text_tbl WHERE t ~>~ 'Worth
SELECT * FROM gpolygon_tbl ORDER BY f1 <-> '(0,0)'::point LIMIT 10;
-SELECT * FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10;
+SELECT circle_center(f1), round(radius(f1)) as radius FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10;
-- Now check the results from plain indexscan
SET enable_seqscan = OFF;