[postgis-users] Problem with EndPoint and Touches Functions

[strk at refractions.net]

On Mon, May 08, 2006 at 01:52:48PM -0400, Jonathan Aguero wrote:
> Dear List,
> 
> I created a point file with the EndPoint function from a line file. Then a
> used the touches function to count how many line segments (from the line
> file previously used to create the point file) touch each endpoint.
> Surprisingly, some of the points have no line segments touching them. I am
> guessing there is a problem with tolerances but how can I work it around?

Can you isolate a failing record and file a bug report ?
Ideally, the testcase would contain a single geometry, in HEXWKB form.
Example:

 CREATE TEMP TABLE geom (g geometry);
 -- LINESTRING(0 0, 10 0)
 INSERT INTO geom VALUES ('0102000000020000000000000000000000000000000000000000000000000024400000000000000000');
 select touch(g, EndPoint(g)) from geom;
 select touch(g, StartPoint(g)) from geom;

--strk;