I have a table like:
Create table gf (
pk serial,
start int,
end int,
gf varchar
);
I want to do queries along the lines of:
"find all gf that overlap with (10000,20000)" or
"find all gf that overlap with each other"
And others. I have read over the documentation, but I still remain unclear
about how to implement R-tree indexing in this situation. Any suggestions?
Thanks,
Sean