> BTW, looking at the SQL99 standard, I see that you can do > > UPDATE table SET ROW = foo WHERE ... > > where foo is supposed to yield a row of the same rowtype as table > --- I didn't dig through the spec in detail, but I imagine foo can > be a sub-select. I don't care a whole lot for that, though, since it > would be a real pain in the neck if you're not updating all the columns. > You'd have to go > > UPDATE table SET ROW = (SELECT table.a, table.b, foo.x, ... FROM foo)
How is the Informix syntax any better? Chris ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
