It's not a win64 issue. My Windows 2008 64-bit 9.1 shows this as closed as well.
George, Are you sure this is the actual geometry you were testing with and not the ST_AsText of it? I suspect you have some long digits making this not closed. Can you please verify this does register as not closed. If so please provide the SELECT version(); and SELECT postgis_full_version(); Regina http://www.postgis.us > -----Original Message----- > From: postgis-users-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@postgis.refractions.net] On > Behalf Of Paul Ramsey > Sent: Monday, June 18, 2012 11:57 AM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] Closed linestring is not closed? > > It returns true for me on OSX64. This is probably another Win64 quirk. > I wonder why that platform has so many more oddities than win32. > P. > > On Sat, Jun 16, 2012 at 12:11 AM, georgew <gws...@hotmail.com> wrote: > > The following linestring which I believed to be closed, and looks > > closed, in fact gives me false in reply to st_isclosed(geom). > > It's probably something very simple which is eluding me but > I am at a > > loss why I get this result. I am using postgis 2.0, Win 7 64. > > Any suggestions?. > > Thank you > > > > select ST_GeomFromEWKT ('SRID=2193;LINESTRING(1581855.1284829 > > 5370000,1581884.80445 5369966.19158,1581887.30288 > > 5369961.19296,1581902.69023 5369908.80888,1581907.78739 > > 5369901.31078,1581945.46961 5369869.11694,1582053.42388 > > 5369814.82165,1582068.01672 5369800.32473,1582058.81757 > > 5369782.83187,1582041.22099 5369762.24115,1582016.32738 > > 5369744.55038,1582008.82968 5369741.95223,1581956.34859 > > 5369744.1582,1581886.27473 5369753.66394,1581876.27826 > > 5369753.56525,1581858.78411 5369750.96838,1581848.78695 > > 5369745.8714,1581826.49107 5369718.28368,1581829.1853 > > 5369683.29527,1581789.4928 5369635.51667,1581784.59315 > > 5369625.42075,1581782.09266 5369615.42448,1581782.19125 > > 5369605.42788,1581762.49236 5369562.74497,1581757.49345 > > 5369557.74732,1581727.60161 5369540.0572,1581717.6048 > > 5369537.45937,1581690.11486 5369539.76211,1581654.93006 > > 5369559.55987,1581644.93496 5369569.45777,1581639.8378 > > 5369576.95587,1581612.24962 5369591.75436,1581597.25527 > > 5369594.15546,1581584.66075 5369601.55455,1581569.56816 > > 5369616.4514,1581567.06973 5369621.45002,1581564.37413 > > 5369646.44183,1581581.67146 5369671.63101,1581614.16168 > > 5369684.32251,1581626.55902 5369696.91662,1581628.95886 > > 5369701.9146,1581628.95989 5369709.41204,1581626.36184 > > 5369716.90982,1581603.67538 5369756.79911,1581598.57889 > > 5369769.19553,1581595.8826 5369789.18905,1581558.00391 > > 5369846.47434,1581532.81696 5369876.36736,1581527.72047 > > 5369888.76378,1581522.42785 5369928.75081,1581494.84072 > > 5369951.1467,1581492.24266 5369958.5445,1581492.04687 > > 5369988.63425,1581488.15835779 5370000,1581855.1284829 5370000)') > > > > -- > > View this message in context: > > > http://postgis.17.n6.nabble.com/Closed-linestring-is-not-closed-tp4998 > > 311.html Sent from the PostGIS - User mailing list archive at > > Nabble.com. > > _______________________________________________ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users