Andrus wrote: > In my current DBMS I can use > > create table t1 ( f1 int, f2 int ); > create table t2 ( f3 int, f4 int ); > update t1 set f1=t2.f3 from t1 left join t2 on t1.f2=t2.f4
That looks like a self-join on t1 without using an alias for the second instance of t1.
I think you meant: update t1 set f1=t2.f3 from t2 where f2 = t2.f4
---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match