[postgis-users] KML: unix vs windows

[Picavet Vincent]

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