On Jan 12, 2008 5:22 PM, Sergei Shelukhin <realgeek(at)gmail(dot)com> wrote:
> 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
UPDATE table1 t1
SET blah = 1
FROM table2 t2
WHERE t1.id = t2.t1id
> If not, is there any way to make UPDATE ... WHERE id IN (....) use indexes?
It depends. Read the docs:
http://www.postgresql.org/docs/8.2/static/using-explain.html
http://www.postgresql.org/docs/8.2/static/planner-stats.html
http://www.postgresql.org/docs/8.2/static/planner-stats-details.html