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.