[SQL] R-tree and start/end queries

[Sean Davis]

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


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly