[postgis-users] Closing a LINESTRING

[strk at refractions.net]

On Sat, Nov 11, 2006 at 10:42:06AM -0800, James G Wilkinson wrote:
> I am not sure this is the correct board for this, but here goes.
> 
> I have a GEOMETRYCOLLECTION that represents a
> meandering line.  It is a valid geometry per ISVALID(), and
> it is not closed per ISCLOSED().  Is there anyway that I
> can insert an additional line into this collection so that ISCLOSED()
> will return true?  That is I want to connect the start point and end
> point of this collection.

See linemerge() manual entry (to use *after* adding the new line
to the collection.

--strk;