Re: Question Regarding Geometric Operators/Function . . .

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Peter E(dot) Chen" <pchen3(at)jhmi(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Question Regarding Geometric Operators/Function . . .
Date: 2002-08-29 20:57:09
Message-ID: 20020829205709.GA28123@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Aug 29, 2002 at 15:51:13 -0400,
"Peter E. Chen" <pchen3(at)jhmi(dot)edu> wrote:
> Hey Everyone,
>
> Does anyone know if there is a geometric operator/function that will allow
> me to determine if a line segment and a point overlap? By overlap I mean
> that the point lies on the line segment. I can't seem to do this with the
> available geometric operators.

There probably isn't an operator to do this because those types are based
on floating point data and you won't be able to reliably determine this.

> Also, can someone explain to me the difference between how postgres defines
> overlap and intersect for its geometric operators/functions.

I am not an expert here, but typically an overlap is something that this
testable (and would be true or false), while an intersection is a set
(and would be some geometric object).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nigel J. Andrews 2002-08-29 21:01:55 Re: [GENERAL] worried about PGPASSWORD drop
Previous Message snpe 2002-08-29 20:22:05 Re: Compiling 7.2.1 with JDBC-Support fails - help needed