"Mike G." <mike(at)thegodshalls(dot)com> writes:
> 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.
> Maybe in a future version the alias can be allowed?
No. It's contrary to SQL spec, and if we allowed it we'd have an
ambiguity: are you assigning to field b_col1 of bb, or assigning
to field b_col1 of a composite-type field named bb in table bb?
regards, tom lane