Re: UPDATE with value from another table

On 2 Mar 2002, Oliver Elphick wrote:

> On Sat, 2002-03-02 at 05:08, Thomas T. Thai wrote:
> > UPDATE [ ONLY ] table SET col = expression [, ...]
> > [ FROM fromlist ]
> > [ WHERE condition ]
> >
> > Is this valid:
> >
> > UPDATE table1
> > SET col = table2.col
> > FROM table2
> > WHERE col = table2.id;
>
> Yes, in principle:
>
> junk=# UPDATE table1
> junk-# SET col = table2.col
> junk-# FROM table2
> junk-# WHERE col = table2.id;
> ERROR: Column reference "col" is ambiguous
>
> WHERE table2.col = table1.id;

right after i emailed the message, i tried it on a large dataset. works.
only gotcha is to drop any unique index first.

--
Thomas T. Thai
Minnesota.com, Inc.