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

[Sébastien Geindre]

Mark Cave-Ayland a écrit :
> 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?
>   

i found !!!
sorry for time lost..

it was  copy/paste between specification document (open office) with 
wrong character inside the insert request !!! i am crazy !!


a question, if the column is specified with srid 4326 for instance, when 
i insert data with -1, what happens ?

thanks for your time.
>
> Kind regards,
>
> Mark.
>
>   


-- 
Sébastien Geindre
DPREVI/AERO/DEV
sebastien.geindre at meteo.fr
05 61 07 84 93


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070622/18a097e0/attachment.html>