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 ([email protected])
T
> -Original Message-
> From: [email protected] [mailto:pgsql-sql-
> [email protected]] On Behalf Of ssylla
> Sent: Tuesday, July 16, 2013 3:58 AM
> To: [email protected]
> Subject: Re: [SQL] update column based on postgis query on anther table
>
> Hi Tom,
>
> I tr
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
--
