Hi.
I was wondering if I could do something similar to this in Postgres and if yes how?
UPDATE table1 SET blah = 1 FROM table1 INNER JOIN table2 ON table1.id = table2.t1id
If not, is there any way to make UPDATE ... WHERE id IN (....) use indexes?