Re: [SQL] SOLVED: update column based on postgis query on anther table

2013-07-16 Thread Stefan Sylla
Hi Igor, thank you so much, the trigger function that you provided is exactly what I was looking for. I already read/heard about the SELECT INTO statement but I never actually understood what it is needed for. Here I go ;-) Stefan -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) T

[SQL] update column based on postgis query on anther table

2013-07-15 Thread Stefan Sylla
Dear list, This might be a postgis-specific question, but I could not get access to the postgis mailing list so I will have a try here as my problem might be related to SQL: I need to update a column of a table based on a postgis-query function that involves another table as follows: Assum