[postgis-users] createtopogeom confusion

[Sandro Santilli]

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------'