[postgis-users] update with Inner join

[svidal at proditecdis.com]

Hi
I have a problem with the update.

I have:

update temp_corr_xxx  set existe = 5
	from  temp_corr_xxx tm
	inner join geom_fincas gf on
		tm.cod_finca = gf.cod_finca and tm.tabla = 12;

and all the table update.

Well, i see in this "list", that

> UPDATE test1 SET value = 10 FROM test1 t1 INNER JOIN test2 ON
t1.extid=test2.extid WHERE t1.id=1;

> This expression update all record i table "test1".

Yup, that's what it should do.  "FROM test1 t1" adds an additional table
reference that's unconnected to the update target table.  You should
have written

UPDATE test1 SET value = 10
FROM test2 WHERE test1.extid=test2.extid AND test1.id=1;

well, but
if i have many inner join?
it's no possible use "table alias" also?

Thank's
Salvador Vidal