Bruno Wolff III <[EMAIL PROTECTED]> writes:
> There is a built in type for line segments that uses floating point. That
> will probably be usable by you directly unless the integers can can large
> enough that precision is a problem. There is an overlaps operator for the
> geometric types that coul
ehalf Of Chris Mungall
> Sent: Wednesday, September 21, 2005 3:14 PM
> To: Sean Davis
> Cc: pgsql-sql@postgresql.org; Hilmar Lapp
> Subject: Re: [SQL] R-tree and start/end queries
>
>
>
> On Wed, 21 Sep 2005, Sean Davis wrote:
>
> > I have a table like:
On Wed, 21 Sep 2005, Sean Davis wrote:
> I have a table like:
>
> Create table gf (
> pkserial,
> start int,
> end int,
> gfvarchar
> );
>
> I want to do queries along the lines of:
>
> "find all gf that overlap with (1,2)" or
> "find all gf that overlap with eac
On Wed, Sep 21, 2005 at 13:52:40 -0400,
Sean Davis <[EMAIL PROTECTED]> wrote:
> I have a table like:
>
> Create table gf (
> pkserial,
> start int,
> end int,
> gfvarchar
> );
>
> I want to do queries along the lines of:
>
> "find all gf that overlap with (1,2
I have a table like:
Create table gf (
pkserial,
start int,
end int,
gfvarchar
);
I want to do queries along the lines of:
"find all gf that overlap with (1,2)" or
"find all gf that overlap with each other"
And others. I have read over the documentation, but I
