Christopher Kings-Lynne wrote: > > > 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?
With Informix, you specify the columns you want updated in parens, rather than saying ROW. Does the spec allow a list of columns after ROW? That would be nice, like Informix. I doubt many folks update all the columns. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
