[GENERAL] UPDATE .. JOIN?

[Sergei Shelukhin]

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?
  

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster