[postgis-users] KML: unix vs windows

[Laurens Jansen]

Hi Vincent,

Enclosed i added a sample sql.dump of the table; i think u should be
able to restore etc and run some tests?

regards laurens

2010/1/18 Picavet Vincent <Vincent.Picavet at mediapost.fr>:
> Hello Laurens,
>
>> ad 1: as_EKWKT? Hmm .. i can't find that function in the postgis
>> functions, perhaps u mean 'asewkt'? A select with that function does
>> give tha same result sets on both platforms:
>> SELECT asEWKT(the_geom) FROM table WHERE gid = 1
>> results UNIX
>> "SRID=28992;MULTIPOLYGON(((121197.452 483388.474 0 0,121194.232643364
>> 483391.530431554 0
>> etc etc
>> results Windows
>> "SRID=28992;MULTIPOLYGON(((121197.452 483388.474 0 0,121194.232643364
>> 483391.530431554 0
>> etc etc
>
> Could you please post a fully self contained example ? Something with
> the geometry itself inside the query, so that I can execute your query
> on my own ? I've got several windows boxes with various flavours of
> windows, postgresql and postgis installed and can test this strange
> behaviour if you give me a working query without prerequisite.
>
> Thanks,
> Vincent
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: table.20100118.sql
Type: text/x-sql
Size: 15174 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100118/96e20cfb/attachment.bin>