Re: What's the fastest way to do this?
От
Carl van Tast
Тема
Re: What's the fastest way to do this?
Дата
Msg-id
1js1vtc3bomp00lcttrpd4ht4rpasuqna5@4ax.com
Список
Дерево обсуждения
Re: What's the fastest way to do this? Orion <o2@trustcommerce.com>
Re: What's the fastest way to do this? Tom Lane <tgl@sss.pgh.pa.us>
Re: What's the fastest way to do this? Stephan Szabo <sszabo@megazone23.bigpanda.com>
On Mon, 12 Nov 2001 11:58:27 -0800, Orion
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
В списке pgsql-general по дате отправления
