<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Mark Cave-Ayland a écrit :
<blockquote cite="mid:1182517514.13836.18.camel@mca-desktop" type="cite">
<pre wrap="">On Fri, 2007-06-22 at 14:56 +0200, Sébastien Geindre wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
<pre wrap=""><!---->
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?
</pre>
</blockquote>
<br>
i found !!!<br>
sorry for time lost..<br>
<br>
it was copy/paste between specification document (open office) with
wrong character inside the insert request !!! i am crazy !!<br>
<br>
<br>
a question, if the column is specified with srid 4326 for instance,
when i insert data with -1, what happens ?<br>
<br>
thanks for your time.<br>
<blockquote cite="mid:1182517514.13836.18.camel@mca-desktop" type="cite">
<pre wrap="">
Kind regards,
Mark.
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Sébastien Geindre
DPREVI/AERO/DEV
<a class="moz-txt-link-abbreviated" href="mailto:sebastien.geindre@meteo.fr">sebastien.geindre@meteo.fr</a>
05 61 07 84 93
</pre>
</body>
</html>