Oleg Bartunov <[EMAIL PROTECTED]> writes:
> seems rtree doesn't ignore NULL ?

Hm, maybe not.  There are explicit tests to ignore null inputs in hash
indexes (hash/hash.c), and I'd just sort of assumed that rtree and gist
do the same.

FWIW, your example doesn't seem to provoke an error in current sources;
but it does take quite a long time (far longer than building a btree
index on 10000 nulls).  That makes me think that indexing nulls in rtree
might be a bad idea even if it works.

                        regards, tom lane

Reply via email to