[postgis-users] Trigger function with ST_Intersects

[Pekka Hurskainen]

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