Re: What's the fastest way to do this? - Mailing list pgsql-general

Orion <o2@trustcommerce.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