A. Kretschmer schrieb:
> am 28.02.2006, um 14:01:44 +0100 mailte pg@os10000.net folgendes:
>
>>update t1
>>set t1f1='test'
>>where t1.t1f2=t2.t2f2
>>and t1.t1f3=t2.t2f3;
>>
>>unfortunately, now I get the error that t2 is not in the FROM clause.
>
>
> You can set
>
> add_missing_from
>
> in yout postgresql.conf, but please read
> http://www.postgresql.org/docs/8.1/interactive/runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION
Better dont do that but use the FROM clause of update:
http://www.postgresql.org/docs/8.1/static/sql-update.html
e.g.
UPDATE t1
SET t1.f1='test'
FROM t2
WHERE t1.t1f2=t2.t2f2
AND t1.t1f3=t2.t2f3;
(although I bet your example is sloppy and you even want t1, t2 and t3 -
so add t3 to the FROM list as you know with SELECT)
HTH
Tino