On Dec 27, 2012, at 10:39 AM, Adrian Klaver <[email protected]> wrote:
> 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=#
