Andreas wrote: > Marek Mosiewicz wrote: > > Upps sorry now found it on TODO list. > > > > I was not aware that it is SQL92 standard. > > > > Is it difficult to implement ? > > Simplest approach would be > > to rewrite it to UPDATE t1 set col1 = (select cola ...), col2 = (select > > colb....) .... > > but it would result in not optimal plan. > > Doesn't something like > > UPDATE t1 SET col1=cola, col2=colb > FROM t1 JOIN anothertable ot ON t1.id=ot.id > WHERE ... > > Work the way you'd like it? I'd expect this syntax to be as widely > portable and performant.
Hmm, 'from' in an update is a PostgreSQL extension to the update command :). Merlin ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html