Problems with UPDATE - Mailing list pgsql-general

Hello everyone,


I am having a strange problem using the UPDATE function in Postgresql.  I
want to move a large number (6000) of entries in one table to another, so
here is my syntax:

UPDATE yeast1 SET c1 = temp.profile_1 FROM temp WHERE yeast1.orf =
temp.orf;

This query results in over 14000 entries being added!  I end up with
multiples of the same entry, which obviously is undesirable.  Does anyone
have any suggestions on how to fix this?

thanks!
Evan