Hi all, I have two table provinces an points of interests. I wanna update province_id column with st_intersects function..
My sql;
update poi set province_id=(
select province.id from
province,poi where intersects(poi.the_geom, province.the_geom)=True group by
province.ogc_fid
)
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
