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                        |
  [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])

Reply via email to