>>>>> "Alexander" == Alexander Korotkov <aekorotkov@gmail.com> writes:
Alexander> 2) NaN coordinates should be processed in GiST index scanAlexander> like in sequential scan.
postgres=# select * from pts order by a <-> '(0,0)' limit 10; a
----------(1,1)(7,nan)(9,nan)(11,nan)(4,nan)(nan,6)(2,1)(1,2)(2,2)(3,1)
(10 rows)
postgres=# set enable_indexscan=false;
SET
postgres=# select * from pts order by a <-> '(0,0)' limit 10; a
-------(1,1)(2,1)(1,2)(2,2)(3,1)(1,3)(3,2)(2,3)(4,1)(1,4)
(10 rows)
this data set was created by:
insert into pts select point(i,j) from (select generate_series(1,100)::float8 union all select 'nan') s1(i),
(selectgenerate_series(1,100)::float8 union all select 'nan') s2(j) order by random();
--
Andrew (irc:RhodiumToad)
