[postgis-users] Help with simple query

Tara Athan tara_athan at alt2is.com
Mon Aug 25 10:06:29 PDT 2008


Adam- there is a right parenthesis missing at the end of your WKT string 
in the second example.
Tara

Adam Vande More wrote:
> From the example here:  
> http://postgis.refractions.net/documentation/manual-1.3/ch04.html#id2620496 
>
> This query works perfectly
>
> INSERT INTO phone_points ( the_geom ) VALUES ( 
> GeomFromText('POINT(-79.988 40.449)'));
>
> However this one fails
>
> INSERT INTO phone_points ( the_geom ) VALUES ( 
> GeomFromText('POINT(-122.38 37.731'));
>
> with
>
> ERROR: parse error - invalid geometry
> SQL state: XX000
> Context: SQL function "geomfromtext" statement 1
>
> Can someone explain why that is an invalide geometery?
>
> Thanks
>


-- 
My e-mail delivery has been unreliable lately, so I am asking for
return receipts from all my email messages.
OK'ing the return receipt lets me know that my message was delivered.
Thank you.

Tara Athan
Principal, Alternatives to Invasive Species
tara_athan [AT] alt2is.com
707-485-1198
PO Box 415
Redwood Valley, CA 95470




More information about the postgis-users mailing list