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
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) or
find all
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 each other
And
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:
Create table gf (
pkserial,
start int,
end
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 could be