[postgis-users] Trigger function with ST_Intersects

Pekka Hurskainen pekka.hurskainen at gmail.com
Mon Jul 11 06:14:45 PDT 2011

Hello list,

I have a point table, and a polygon table. The polygon layer contains
a column which I want to use to populate a similar column in the point
layer, using ST_Intersects (point in polygon overlay).

I want to write this query into a trigger function, which will run the
above query every time a new point is added.

This should be very trivial query but I don't seem to get the syntax
right. Any help very much appreciated!

Pekka Hurskainen

More information about the postgis-users mailing list