quirk with update a from b

Поиск
Список
Период
Сортировка
Искать
От
Mike G.
Тема
quirk with update a from b
Дата
Msg-id
20060322205606.GA1839@localhost.localdomain
Список
Дерево обсуждения
quirk with update a from b "Mike G." <mike@thegodshalls.com>
Re: quirk with update a from b Tom Lane <tgl@sss.pgh.pa.us>
CREATE TABLE aa
(
a_col1 text
);

CREATE TABLE bb
(
b_col1 text
);

This update works:
UPDATE bb 
SET b_col1 = aa.a_col1
FROM aa
WHERE bb.b_col1 <> aa.a_col1;

This does not:
UPDATE bb
SET bb.b_col1 = aa.a_col1
FROM aa
WHERE bb.b_col1 <> aa.a_col1;

Error: column "bb" of relation "bb" does not exist.

postgres 8.1.2

Maybe in a future version the alias can be allowed? Perhaps someone wanted to avoid updating the wrong column on accident and put this in as a safety net?

Mike


В списке pgsql-general по дате отправления
От: Guy Fraser
Дата:
От: Tony Caduto
Дата:
FAQ