# [postgis-users] INSERT problem

TECHER Jean David davidtecher at yahoo.fr
Mon Sep 27 03:01:26 PDT 2004

```bonjour guillaume

en fait, il a raison

MULTIPOLYGON(((...)))>>>> 3 groupes de parenthèses

et POLYGON((...)) >>>> 2 groupe de parenthèses

Faut pas aussi oublier GeometryFromText('......',Ton_srid)
----- Original Message -----
From: "Kevin Jardine" <kevin.jardine at int.greenpeace.org>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Monday, September 27, 2004 11:52 AM
Subject: Re: [postgis-users] INSERT problem

> I believe that you are missing a set of brackets after MULTIPOLYGON. A
> POLYGON is a list of rings and has two sets of brackets. A MULTIPOLYGON
> is a list of POLYGONs and so has 3 brackets.
>
> Cheers,
> Kevin
>
> Guillaume SUEUR (Géosignal) wrote:
>
> > HI there,
> >
> > This statement :
> >
> > INSERT INTO polysTemp (idSession, taille, couleur, interieur,the_geom)
VALUES
> >
('94d91bd4793280a26ba83abe4abc3412','5','33CC00','33FF66','MULTIPOLYGON((526
802
> > 154535, 517313 148794, 515240 142414, 521539 139225, 528557 139225,
534139
> > 145604, 532943 152781, 526802 154535))');
> >
> > returns
> > *Warning*: pg_query(): Query failed: ERROR: couldnt parse object in
GEOMETRY
> >
> > What's wrong ? It works with MULTILINESTRING on another table.
>
>
> --
> Kevin Jardine
> New Media Campaigner
> Greenpeace International
>
> Tel: + 31205148150 (main switchboard)
> Mobile: + 31652062980
>
> Become a cyberactivist!
> http://act.greenpeace.org/register
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>

```