SQL adaptation guide For PostgreSQL 8.x.y, 9.x.y / Data manipulation |
Informix® allows a specific syntax for UPDATE statements:
UPDATE table SET ( col-list ) = ( val-list )
Or
UPDATE table SET table.* = codeph.*
UPDATE table SET * = myrecord.*
UPDATE table SET column=value [,...]