Re: update column based on postgis query on anther table

Stefan Sylla <stefansylla(at)gmx(dot)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
> new.id_test1_poly=test1_point_get_id_test1_poly(new.id);
> return new;
> end;
> $$
> language plpgsql volatile;
> -- create trigger for function:
> create trigger test1_point_get_id_test1_poly
> after insert or update on test1_point for each row execute procedure
> test1_point_get_id_test1_poly();

I think you need that to be a BEFORE insert or update trigger. In
an AFTER trigger, it's too late to affect the stored row.

regards, tom lane