Hello,
I need Postgres support for the following update syntax :
update table1 set (col1, col2, col3) = (select f1, f2, f3 from table2
where id=5) where rownum=3;
update table1 set (col1, col2, col3) = (select f1, f2, f3 from table2
where id=table1.parentid) where rownum=3;
These type of update statements are the only ones supported by Oracle
to update one table from another.
Can this be added to the TODO list?
Can a cash prize be associated with the TODO item?, I have $1000US
allocated for this.
-ESR-