Hi Tom,
I tried changing the trigger to be BEFORE instead of AFTER:
create trigger test1_point_get_id_test1_poly
before insert or update on test1_point for each row execute procedure
test1_point_get_id_test1_poly();
But the problem persits, the column id_test1_poly remains empty.
Stefan
-Original Message-
From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-
ow...@postgresql.org] On Behalf Of ssylla
Sent: Tuesday, July 16, 2013 3:58 AM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] update column based on postgis query on anther table
Hi Tom,
I tried
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)
