I'm pretty sure that the "into hydro_counties" is meant to go after the entire 
select statement (after the from and where clauses too).

What is the exact error it gives?

Chris

> By the way, is there any way to aks postgis to output only polygons without
> making
> it compute the intersection twice? (This is what I would expect as a user, a
> column of type
> MULTYPOLIGON that contains only polygons). I've tried with:
> 
> select intersection(counties.the_geom, hydrounit_poly.the_geom) as inter,
> counties.county,
> hydrounit_poly.map_label, hydrounit_poly.reg_name
> into hydro_counties
> from counties, hydrounit_poly
> where counties.the_geom && hydrounit_poly.the_geom
> and (GeometryType(inter) = 'POLYGON' || GeometryType(inter) ==
> 'MULTIPOLYGON')
> 
> but the parser does not like it.



