You are right, and Thank you very much for your answer.
Best regards...
Ayhan Tekgul
---- Original Message ----
From: Nicolas Ribot <[email protected]>
To: "PostGIS Users Discussion" <[email protected]>
Sent: Paz, Eki 2, 2011, 16:44 PM
Subject: Re: [postgis-users] ERROR: invalid input syntax for integer: "POINT(389 418.12 4420549.100044)"
Hi,
There is a missing comma in geomFromText, between the geometry definition and the SRID value:
INSERT INTO pol_p (x, y,the_geom) VALUES (0, 0, GeomFromText('POINT(389418.12 4420549.100044)', -1));
Nicolas
> Hi,
>
> I am trying to insert geometry information into a point table. But when I
> try to execute following query, I am getting " ERROR: invalid input syntax
> for integer: "POINT(389418.12 4420549.100044)" " message. I cannot get a
> solution from my searches.
> Is there anyone who has solution to this problem?
>
> QUERY :
>
> INSERT INTO pol_p (x, y,the_geom) VALUES (0, 0,
> GeomFromText('POINT(389418.12 4420549.100044)' -1));
>
> ERROR :
>
> ERROR: invalid input syntax for integer: "POINT(389418.12 4420549.100044)"
>
> Here is my table SQL statement :
>
> CREATE TABLE pol_p
> (
> gid serial NOT NULL,
> the_geom geometry(Point,2097151),
> x double precision DEFAULT 0,
> y double precision DEFAULT 0,
> CONSTRAINT pol_p_pkey PRIMARY KEY (gid )
> )
> WITH (
> OIDS=TRUE
> );
>
>
> Best regards...
>
> Ayhan Tekgul
>
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
