On Jan 12, 2008 5:22 PM, Sergei Shelukhin <realgeek@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
