[postgis-users] update an st_intersects

[ibrahim saricicek]

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
)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100126/f74f84c0/attachment.html>