Kevin Kempter wrote on 03.04.2012 19:29:
Hi All; I have a query that wants to update a table based on a join like this: update test_one set f_key = t.f_key from upd_temp1 t, test_one t2 where t.id_number = t2.id_number upd_temp1 has 248,762 rows test_one has 248,762 rows
To extend on what Kevin has already answere: Quote from the manual: "Note that the target table must not appear in the from_list, unless you intend a self-join" -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
