[postgis-users] update an st_intersects

[ibrahim saricicek]

Hi all,

I have two tables; provinces an points of interests. I wanna update
province_id column with st_intersects function..

My sql;

update poi set province_id=(
select province.ogc_fid from province,poi where intersects(poi.the_geom,
province.the_geom)=True group by province.ogc_fid
)

The message is

ERROR: more than one row returned by a subquery used as an expression

What should I change?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100126/0bcc9ecf/attachment.html>