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

On Mon, 12 Nov 2001 11:58:27 -0800, Orion <o2@trustcommerce.com>
wrote:
>[...]
>UPDATE test
>        SET description = x.description
>        FROM test AS rt, test_tmp AS x
>        WHERE rt.code = x.code;
This seems to work:
UPDATE test SET description = x.description
        FROM test_tmp x
        WHERE test.code = x.code;

Kind regards
 Carl van Tast