On Fri, 2007-06-22 at 14:56 +0200, Sébastien Geindre wrote: > my example is wrong, in fact i have 16 column but for the post i try to > keep 3 column.... > but the pb comes from lat/lon precision...of format but from Polygon WKT > format... > sorry
Okay, then let's try a simple test case: CREATE TABLE foo AS (id int, the_geom geometry); INSERT INTO foo (id, the_geom) VALUES (1, GeometryFromText('POLYGON((0.672702 49.9706, 3.90024 49.97063, 3.90024 47.6684, 0.672702 47.6684, 0.672702 49.9706 ))', -1 )); SELECT astext(the_geom) FROM foo; Does this work for you? Kind regards, Mark. -- ILande - Open Source Consultancy http://www.ilande.co.uk _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users