[postgis-users] WKT specification ?? Lon/Lat precision ?

[Mark Cave-Ayland]

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