Re: What's the fastest way to do this?

Orion <o2(at)trustcommerce(dot)com> writes:
> UPDATE test
> SET description = x.description
> FROM test AS rt, test_tmp AS x
> WHERE rt.code = x.code;

This command is a three-way join between test AS test (the target),
test AS rt, and test_tmp AS x. Almost certainly not what you want,
especially considering that the target table is not constrained at
all by the WHERE clause.

regards, tom lane