[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:

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

2013-07-15 Thread Tom Lane
Stefan Sylla stefansy...@gmx.de writes: Now I want to use a trigger function to automatically update the column 'id_test1_poly' in tabel 'test1_point': /**/ create or replace function test1_point_get_id_test1_poly() returns trigger as $$ begin