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

[Mark Cave-Ayland]

On Fri, 2007-06-22 at 14:16 +0200, Sébastien Geindre wrote:
> Hi all,
> 
> any explanation why these request does not work 
> 
>  INSERT INTO ICE_GEOM (ID, TYPE,  ICE_POLYGON) 
>  VALUES (2, 'ice', 'FME', 
> 	GeometryFromText('POLYGON((0.672702 49.9706, 3.90024 49.97063, 3.90024 47.6684,
> 				   0.672702 47.6684, 0.672702 49.9706 ))', -1 ));
> 
> 
> and this one works :
> 
> 
> INSERT INTO ICE_GEOM (ID, TYPE,  ICE_POLYGON) 
>  VALUES (2, 'ice', 'FME', 
> 	GeometryFromText('POLYGON((0.67 49.97, 3.90 49.97, 3.90 47.66,
> 				   0.67 47.66, 0.672 49.97 ))', -1 ));
> 
> 
> The difference is just the precision of LONG,LAT.
> The ICE_GEOM column has -1 SRID...
> 
> 
> Where can i find WKT specification ?
> 
> 
> Thanks
> 
> 
> -- 
> Sébastien Geindre


Hi Sebastien,

It looks like you are missing a column in your column list - you have 3
column names but 4 values, so PostgreSQL is probably trying to insert
into the wrong column.


Kind regards,

Mark.

-- 
ILande - Open Source Consultancy
http://www.ilande.co.uk