Re: [MonetDB-users] SQL: Update table from another table

Andrei Martsinchyk wrote:

Hello Fabian,

I am not sure about 2003, Postgres' docs say that UPDATE ... FROM is their extension.

Ohw, then they have it, like MS SQL Server has it. It is a useful extension.

Could you suggest any workaround ?

No, it is not possible to do it. You can only do it using a software approach. It's a short comming of the standard IMHO.

monetdb-> update t1 set val1 = (select val2 from t2 where id1 = id2) where id1 in (select id2 from t2); Error: ERROR: interpret: unknown variable 's23'. ERROR: interpret_params: join(param 2): evaluation error.

This is a bug, by the way.