What a fuck postgre update sql

================= What a fuck postgre update sql =================

UPDATE temp_group_temp set group_id=c.group_id from temp_group_view_2000 C where
temp_group_temp. User_id=cast (c.user_id as bigint);

================= What a fuck postgre update sql =================

Because of the wrong reasons, so I have to go back today, want to use Postgre to update the field from one table to another table, using aliases, always say that the alias is associated with the table does not exist.

Toss (what degree Niang, Google, key can find things or be blocked, nausea) for one hours, no fruit.

Helpless, think of a manual update statement, but think of the convenience of Oracle, thought, there is no way to automate the implementation of the method.

Finally, try to use the table name instead of the alias, and the result is successful.

Write this to commemorate the one hours wasted by the PostgreSQL update alias, and hope that people who meet the same situation will save time by seeing this.

In fact, I like Oracle very much.