Hi Andrei, If I recall correctly, this use of the UPDATE is not in the SQL99 standard. I would have to check against SQL2003 to see if it now it, because PostgreSQL is in general quite compliant with the spects. The short answer for now is "no". It is not accepted by the parser at the moment, and surely is not supported in the frontend. Do you know perhaps if this is in the 2003 standard? Someone else who knows/can check? Andrei Martsinchyk wrote:
Hello All,
Does SQL frontent support updating one table with data from another table ? More formally, if I have two tables
create table t1 (id1 int, val1 varchar(255)); and create table t2 (id2 int, val2 varchar(255)); ,
can I execute statement like this (PostgreSQL syntax):
update t1 set val1=val2 from t2 where id1=id2; ?
Thanks in advance.