Helllo.

I want to implement knn for spgist. I dont have question with knn, but have questions with implementation of interface.

i modify pg_am.h (set amcanorderbyopš to true in spgist index).Also i modify pg_amop.h(add

DATA(insert (ššš 4015šš 600 600 15 o 517 4000 1970 ));

)

explain SELECT * FROM quad_point_tbl ORDER BY p <-> '-2,50'

šSortš (cost=1219.31..1246.82 rows=11003 width=16)
šš Sort Key: ((p <-> '(-2,50)'::point))
šš ->š Index Only Scan using sp_quad_ind on quad_point_tblš (cost=0.15..480.70 r
ows=11003 width=16)

what am I doing wrong?

In a gist index we have :

regression=# explain SELECT * FROM point_tbl ORDER BY f1 <-> '-3,0';
šššššššššššššššššššššššššššššššš QUERY PLANšššššššššššššššššššššššššššššššš
----------------------------------------------------------------------------
šIndex Scan using gpointind on point_tblš (cost=0.13..8.27 rows=7 width=16)
šš Order By: (f1 <-> '(-3,0)'::point)
šPlanning time: 0.166 ms
(3 rows)

Are there documents about modification access methods?

Thanks.

Constantine Kuznetsov