> > > AFAIR, none of the index access methods except btree > > > handle NULLs at all --- they just ignore NULL values > > > and don't store them in the index. ... > > and what does this error means ? > > create table rtree_test ( r box ); > copy rtree_test from stdin; > \N > ........ total 10,000 NULLS > \. > > create index rtree_test_idx on rtree_test using rtree ( r ); > --ERROR: floating point exception! The last floating point > operation either exceeded legal ranges or was a divide by zero > > seems rtree doesn't ignore NULL ? No, it doesn't. As well as GiST. Only hash ignores them. And there is no code in GiST & rtree that take care about NULL keys. It's probably ok for GiST which is "meta-index" - index/type methods implementator should decide how to handle NULLs. As for rtree - seems it's better to ignore NULLs as we did before for single key btree: rtree is just variation of it. Vadim