Sent from my iPhone
İ
On 16 Tem 2013, îat 08:24, Tom Lane t...@sss.pgh.pa.us wrote:
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
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
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:
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