No. Some questions though.
Thanks for the reply Adrian.
What version pf Postgres?
9.1
Is that the actual UPDATE statement, I see no SET?
I was reading the docs but obviously don't understand the syntax of the update statement.
Have you tried it?
If so and it failed what was the error?
Yes and I got an error at or near from. Like this:
b4warmed3=# UPDATE sixty_min FROM tmp_60 WHERE sixty_min.rowid = tmp_60.rowid;
ERROR: syntax error at or near "FROM"
LINE 1: UPDATE sixty_min FROM tmp_60 WHERE sixty_min.rowid = tmp_60....
^
b4warmed3=#