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