[postgis-users] createtopogeom confusion

[Chris English]

Thanks.  I knew it wasn't related to Topology,
but my postgresql skills.  This is now, the first and
only documented, somewhat simple explanation
of what one does with one's first biggish topology
to CreateTopoGeom between the conference material and
complex examples in Postgis Topology.

So thanks, thanks, thanks from the merely mortal.
I'll report my progress.

Chris

----------------------------------------
> Date: Wed, 14 Dec 2011 17:51:06 +0100
> From: strk at keybit.net
> To: postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] createtopogeom confusion
>
> On Wed, Dec 14, 2011 at 11:36:04AM -0500, Chris English wrote:
>
> > Insert into union_cty_topo.summit_fa (g)
> >     values (
> >     topology.createtopogeom(
> >     'union_cty_topo', --topo name
> >     3, -- type areal
> >     2, --layer id
> >     foo.faces)
> >     from ( select topology.topologyelementarray_agg(array[union_cty_topo.face_id,3]))as faces
> >     )
> >     )as foo;
> >
> > ERROR:  syntax error at or near "from"
>
> This is really unrelated to Topology.
> You'll need something like:
>
> INSERT INTO union_cty_topo.summit_fa (g)
> SELECT topology.createtopogeom(
>     'union_cty_topo', --topo name
>     3, -- type areal
>     2, --layer id
>     topology.topologyelementarray_agg(array[face_id,3])
>     ) from union_cty_topo.face
> WHERE face_id > 0;
>
> NOTE: not checked.
>
> > trying firefox for verticle, but probably doesn't matter, a hotmail problem
>
> Better than nothing.
>
> --strk;
>
> ,------o-.
> | __/ | Thank you for PostGIS-2.0 Topology !
> | / 2.0 | http://www.pledgebank.com/postgistopology
> `-o------'
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users