Re: Fix picksplit with nan values

>>>>> "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)