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

[Sébastien Geindre]

Mark Cave-Ayland a écrit :
> 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.
>   
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
>
> Kind regards,
>
> Mark.
>
>